AD 48-39-01
Registered aircraft · 5,583
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:48-39-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:48-39-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:48-39-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:48-39-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.
N1060EMelick Frederick J · Sandusky, OHN1061ENeal Foster Trucking Inc · Woodland, CAN1063EFenton Harry L · Rockton, ILN1064EBurner Dwight L · Mcgaheysville, VAN1067EGelvin Stanley M · Central, AKN1069EChamp Wilson E · Lebanon, PAN1071EGiannonatti Lance A · Ludlow, SDN1072ESabbatino Robert F · New Milford, CTN1073EMurphys Flying Service LLC · Thomasville, GAN1074LPurpose Flight Inc · Wilmington, DEN1075EWeiland Adam W · Evergreen, CON1077EGoebel William R · Rhome, TXN1078EBuehler Benjamin M · Issaquah, WAN1079EEastern Stearman Inc Trustee · Leesburg, VAN107ZCHemphill Holdings LLC · Hemphill, TXN1082EKnerr Joshua D · Tehachapi, CAN1084EPetro Jerry R · Williamsburg, VAN1086EPippert James · Dysart, IAN1087EBrindley Matthew · Kalamazoo, MIN1088ESmith Mark E · Lakeville, NYN1090ECrouse John A · Sterling, AKN1094EHardin John M · Terrell, TXN1095EIndependent Dusting Service Inc · El Campo, TXN1096EMarrs David R DBA · Bella Vista, ARN1097ERegistration Pending · Manley Hot Springs, AKRegistration pendingN10982Burris Kye A · Gillett, ARN10983Blakesley Eric R · Canandaigua, NYN10985Lozier Kurt T · Albany, NYN10987Andreassen Ray E · Delta Junction, AKN10989Rickert Randy M · Lehighton, PAN1098EKruse Robert M · Liberty, MON10990Speed And Angels LLC · Dover, DEN10ANSouth Dakota Hist Avn Preservation & Educ Soc Inc · Canistota, SDN10BYKing Air LLC · Navasota, TXN10HNMcaleer John J · Bermuda Dunes, CAN10JZDhz LLC · Cincinnati, OHN1101EChristensen John N · Greenville, MIN11022Tailwheel Solutions LLC · Wilmington, DEN11023Kyser Donald J · St Paul, MNN11025Edmunds Brenda L · Tallahassee, FLN11026Allen David L · Surfside Beach, SCN11028Rush Casey K · Troy, KSN11029Benner James M · Great Falls, MTN1102ELee Robert J Trustee · Denver, NCN1103Schmidt Thomas P · Nunica, MIN11031Griffin Brian · Nashville, GAN11033Keller Lee J · Minot, NDN1103EPhantom Flyer LLC · Yelm, WAN11041Quad Aviation LLC · Branchville, NJN11042Hogsten-Anderson Niklas Erik · Jupiter, FL
Back to AD 48-39-01