AD 2026-22-13
Registered aircraft · 47,597
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:2026-22-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2026-22-13')
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:2026-22-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2026-22-13') 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.
N10009Hendrickson Flying Service Inc · Rochelle, ILN1000SButler County Warbirds Inc · Middletown, OHN1001A1st Avenue Ttc LLC · Los Angeles, CAN1001FAg Air Inc · Cheyenne, WYN1001MRocky Mountain Ventures Inc · Cheyenne, WYN1002HSmith Michael S · Anchorage, AKN1002MSchuler Mark E · Columbia, ILN10034Whyte Henry T Jr · West Ossipee, NHN1003CRogers Justin T · Kalispell, MTN1004DGiezen Jurgen J · Fairfax, VAN1004HSmtm Holdings Inc · Wilmington, DEN1004MReid Brian · Boise, IDN1004PVankirk Malcolm R · Frederick, MDN1004XRegistration Pending · Yucaipa, CARegistration pendingN1007UKallam Jerry · Palmer, AKN1008EEdwards Gregory S · Guthrie, OKN1008MHottenstein William R · Kingston, PAN1008WRay Jonas · Palmer, AKN1008XSmith Dan V · Anchorage, AKN1009AWilliams Wendell · Anchorage, AKN100AESale Reported · Spencer, NESale reported, pending cancellationN100BVHoward Keith · Fayetteville, NCN100CDVenhaus Randy J · Cordova, TNN100CGGreene Carol W · Mahwah, NJN100DDCook Allen J · Aurora, CON100DFFisher Charlton Dru · Houston, TXN100DPEskind Thomas O Jr · Dallas, TXN100EEConcho Aviation LLC · Sterling City, TXN100HTMitchell Brian N · Scottsdale, AZN100HX14 Aero Spaces LLC · Wilmington, DEN100JGClub Cherokee Inc · Crystal, MNN100JVKremers Gary · Zeeland, MIN100KCMiller Byron W · Silverton, ORFirst renewal noticeN100LDPenning Jeffrey D · Clear Lake, IAN100LGFlyd Pipers Inc · Dyer, INN100LWN100lw LLC · Hickory, NCN100MSky Odyssey Aviation LLC · Gulf Breeze, FLN100PBDoobie Air LLC · Wilmington, DEN100PTJacobs Brian E · Aptos, CAN100QBShutt Ryan T · Eden, NYN100RFN100rf Ghost LLC · Burleson, TXN100RKEllingson Leslie B · Harwood, NDN100SQBowles Chris · Taylorsville, NCN100SVKretschman Thomas J · Verona, WIN100THWhiddon Mark H · Frankston, TXN100TNMoore Glenn C · Elkhart Lake, WIN100UDVogel Kelly C · Ventura, CAN100WHTowb Parmalee · Chula Vista, CAN100WRBuehler Andrew · Eatonville, WAN100WWSwearengin David · Lula, GA
Back to AD 2026-22-13