AD 2000-06-01
Registered aircraft · 39,302
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:2000-06-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:2000-06-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:2000-06-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:2000-06-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.
N1165MArsene Eddy R · Lynnwood, WAN1165UWings Over Texas Holdings LLC · Denton, TXN1166FMortensen Alex · Burley, IDN1166MWarren Gregory C · Redmond, ORN1166VClark John A · Windsor, CAN1167FRegistration Pending · Cotter, ARRegistration pendingN1167VBoard David N · Woodsfield, OHN1168FAnderson Jeffrey A · Runaway Bay, TXN1168VGood Guys Flying Club LLC · Colorado Springs, CON1169FJensen Richard · Cayucos, CAN1169QRohde Allen G · Eagle River, AKN116AHRegistered aircraftN116AKLucas Kelly W · Wasilla, AKN116CRConti Christine M · Plantation, FLN116FPRandall David J · Balsam Lake, WIN116HRRedpaw Aviation Ltd · Upper Arlington, OHN116LHC&L Holzwarth Inc · Virden, ILN116SUBoolean Flight Sciences LLC · Mercer Island, WAN1170FHowerton Kurt · Groveland, CAN1170MBryson William H III · Cook, MNN1170VPadgett Keith A · Bow, WAN1171FBlohm Paul J. · Tiffin, OHN11723Rader Mark Todd · Deland, FLN1172FLincoln Meagan C · Kotzebue, AKN1172GSkranak James Robert · St Maries, IDN1172MTodd Kevin E · Bismarck, NDN11730Sendelbach John W · Cochrane, WIN11731Dupree Wesley W · Molena, GAN11732Lewis Nathan Alan · Crestline, CAN11738Tat Networks And Aviation LLC · Bend, ORN1173CHolland Todd D · Mendota, ILN1173FTrue Course LLC · West Monroe, NYN1173MFlathead Lake Aviation LLC · Polson, MTN1173QMoon Mitchell L · Covington, GAN11746Flying Panthers Flight School Inc · Citrus Heights, CAN11748Kilber Ronald P · Salome, AZN11749Adams Chad R · Joplin, MON1174MWhitted Danny E · Candler, NCN11756Creswell Philip M · Camden, ALN1175MRj Freebird LLC · Driftwood, TXN11766Haig Dennis A · Andover, KSN1176UPlane Leasing LLC · Wilmington, DEN11771Boss Gary W · Bronston, KYN11772Pope John P · Chehalis, WAN11775Witzel Daryle L · Porterville, CAN11779Talbert Robert David · Granbury, TXN1177FSeaman Kenny James · Edgewood, TXN1177RN1177r LLC · Marshall, MIN11786Barbee Donald L · Columbus, OHN1178COliveira Frank Jr · Pawtucket, RI
Back to AD 2000-06-01