AD 90-04-06 R1
Registered aircraft · 68,377
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N4207YAnderson John A · Palmer, AKN4208HDahmes Bradley M · Hawick, MNN4208XDeaton Timothy W · Norfork, ARN4208YScout Towing Company · Omaha, NEN42095Cpkb · Summit, NJN4209GMhoc LLC · Pensacola, FLN4209HKirby Ronald S · Delta Junction, AKN4209MWahl Joseph Lewis · Elizabeth, CON4209PN4209p LLC · Eagle River, WIN4209QLakeland Aviation Of Minocqua Inc · Minocqua, WIN4209XSimmons Scott E · De Queen, ARN4209YShilt Jerry C · El Dorado Springs, MON4209ZBy Sky Or By Sea LLC · Kalispell, MTN420FMcmullen Morrell E · Angleton, TXN420FPSky Ventures LLC · Flagstaff, AZN420GBOnemanconcrete LLC · Thaxton, VAN420GNNorsworthy Garry Lynn · Grapeland, TXN420KWCleghorn Aviation Inc · Key West, FLN420LPCross Todd J · Johnstown, CON420RMCummiskey Ryan J · Jamesville, NYN420TVictor James A · Santa Ynez, CAN420TCBowling Green Flight Center LLC · Bowling Green, OHN420URcs Services LLC · California, MDN420VHodges Mcneill Jr · Andersonville, GAN4210HGage Ricky Duane · Lewiston, IDN4210JPlamondon Steven J · Lake Leelanau, MIN4210QKoehn Jerome D · Fairview, OKN4210ZMccarthy Gary W · Chugiak, AKN42111Blanchfield Christine Lizabeth · Devils Lake, NDN42117Sturdivant Marshall J · Ellijay, GAN42118Walsh Air LLC · Live Oak, FLN42119Strouckel Ronnie J · Roscoe, SDN4211HRn Roofing LLC · Brandon, MSN4211J11j Inc · Fort Lauderdale, FLN4211MMccartan Gary M · Pocahontas, IAN4211NTaylor Dale W · Cape Fair, MON4211QJwmp Air Inc · East Moriches, NYN4211XClyde A Russell · Redlands, CAN42126Zrelak Patrick · Apple Valley, CAN4212HG And H Aviation · Louisville, KYN4212MMiller Taylor Robert Mamouney · North Bend, ORN4212TAci Medical Management Inc · San Marcos, CAN42138Cape May Aerial Advertising LLC · Rio Grande, NJN4213HWiese Ryan Mark · Eagle River, AKN4213MNatale William F · Saratoga Springs, NYN4213PLohse Teal K · Cordova, AKN4213QFogarty Aviation Inc · Wasilla, AKN4213TMallard Aviation LLC · Manchester, NHN4213YFandrich Edward I · Payson, AZN4214HGranger Andrew J · Denver, CO
Back to AD 90-04-06 R1