AD 2001-08-08
Registered aircraft · 5,765
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:2001-08-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-08')
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:2001-08-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2001-08-08') 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.
N113VSaravis Darren S · Long Beach, CAN113XClement James G · Cresson, TXN11421Beach Prairie LLC · Cedar Rapids, IAN114JDVintage Motors Inc · Beattyville, KYN114PLMaxwell Jeffreyi · Drayden, MDN114TPGrj LLC · Lexington, SCN114WRRib Runner LLC · Sioux Falls, SDN1156TAero 1 LLC · Kalispell, MTN1157TSalloom Mary M · Gaithersburg, MDN115CA8k Entertainment Inc · Wells, MEN1165TFlying J Partners Asset Management LLC · Casper, WYN1169TMorin Daniel P · New Harbor, MEN116BDTxbd Investments LLC · Addison, TXN116TWHatfield David A · West Ossipee, NHN1170TJf Capital Series LLC · Truckee, CAN1178TDavis Aviation Group LLC · Gastonia, NCN1179TQuad Rabbit Inc · Wilmington, DEN117ECRambana & Ricci Pllc · Tallahassee, FLN1183ABronson Nw Inc · Redmond, ORN1184JD&D Chessies LLC · Wilmington, DEN118CMEastport Vacation LLC · Wilmington, DEN118NHSouthern Aircraft Consultancy Inc Trustee · Casper, WYN118TBColtman Peter O · Colleyville, TXN118VSmith Gregg W · Lake Jackson, TXN1194AGta Air Inc · Addison, TXN1195TRoberts Robin W · Birmingham, ALN119EWBte Aviation LLC · Wilmington, DEN119RBDetroit Lakes Aviation Inc · Detroit Lakes, MNN119TTBurrell Anthony · Stillwater, OKN11BXMatthew K Cole · Gillespie, ILN11GMPlatt Tony E · Riverside, CAN11HTJet X Leasing Inc · Johnson, KSN11JBFlight Risk Ventures LLC · Missoula, MTN11JQLosey Charles N Jr · Oneida, TNN11KSFaulkner Dale R · Burnet, TXN11RTBraly And Braly Pc · Ada, OKN11VBRobertson Matthew · Nashville, TNN11VGSage Aviation LLC · Saint Louis, MON11VZLowcountry Flight LLC · Johns Island, SCN11WPPlacer Aviation LLC · Loomis, CAN11XMWesley F Walker · Rock Hill, SCN120DBB & I Leasing LLC · Berryville, VAN120MPHall William M · Encinitas, CAN1212GNickeson Family LLC · Maquoketa, IAN121AMEastern Stearman Inc Trustee · Leesburg, VAN121BEKrdm LLC · Fallon, NVN121DSongbird Aviation LLC · Larkspur, CAN121RWArbuckle Air LLC · Kansas City, MON121YPNine Five Alpha LLC · Huntsville, ALN1222MHagarty Matthew · Coralville, IA
Back to AD 2001-08-08