AD 75-16-01
Registered aircraft · 17,795
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:75-16-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-01')
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:75-16-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-16-01') 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.
N1236FPitcher Michael C · Mancelona, MIN1236MRutherford Dustin · Simi Valley, CAN1237Fraser Mark L · Fairfield, CAN1239FValpey R Wesley Jr · Medford, MEN1239MMonarch M Miller · Ocala, FLN123ARRullan Alberto · Adjuntas, PRN123DBN123db LLC · Madison, NJFirst renewal noticeN123DLNiche Advertising Solutions Inc · Statesboro, GAN123EPFalkenberg Randy J · Edmonson, TXN123GLAir Care Leasing LLC · Lamar, CON123KLWings Over The Rockies LLC · Wittmann, AZN123LJRegistered aircraftN123TMJaars Inc · Waxhaw, NCN123TZSouthside Truck And Trailer Inc · San Antonio, TXN123UPApache Underground And Excavating LLC · Lakeside, AZN123VJKopp Daniel D · Buckeye, AZN123WGThornhill Shaun · Greenville, OHN1240MElk Creek Investments LLC · Helena, MTN1242MHenninger Bradley J · Green Cove Springs, FLN1243MRegistered aircraftN1245BPositive Flight LLC · San Ramon, CAN1245SMccain Michael E · Sun Valley, NVN1247SShurma Ramesh · Hayward, CAN1248EBoling Derek · Paragould, ARN1248SBodolay John M · Fredericksburg, VAN1249SClemans Alan J · Guymon, OKN124BSLeair LLC · Eufaula, ALN124EFGuerrer Daniel S · Redondo Beach, CAN124KChicken Hawk Aviation LLC Series 2 · Waxahachie, TXN124LRWilson David J · Palmer, AKN124SKAgarwal Sanjai K · Monroe, NJN124UAKagerer John A Trustee · Anchorage, AKN124WHHillcrest Aircraft Co Inc · Lewiston, IDN124WJSessions Thomas Eric Trustee · Huffman, TXN124WMDenton James Manley Jr · Cabot, ARN124WNTemple Steve D · Superior, MTN1250MBlakley John · Cascade, IDN1250SNew Oasis Market Inc · Blacksburg, VAN1250WScherff Lewis H Trustee · Inver Grove, MNN1251BJagow Charles Philip · Fairbanks, AKN1251DErjoaero LLC · Stuart, FLN1251SPt Air LLC · Madison, WIN1252EStedje Timothy M · Gruver, TXN1252MNyquist David · Boulder, CON1253QLibbyn The Dream Fishing Team LLC · Anchorage, AKN1253SHale Jeffrey D · Reno, NVN1254SStewart Donald K · Holbrook, MAN1255MCammack Lockwood P · Mount Pleasant, TXFirst renewal noticeN1255VHanson Lanny Lane · Polson, MTN1256SBrant P Rouse Dds Plc · Tahlequah, OK
Back to AD 75-16-01