AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N2339VBradford Sarah Elisabeth · Norman, OKN2339YGross Barbara J · Timber Lake, SDN233AAAoa Kissimmee Inc · Kissimmee, FLN233CBZions Credit Corp · Salt Lake City, UTN233CPCivil Air Patrol · Maxwell Afb, ALN233CRWilliams Charles H · Granbury, TXN233DCMc Aviation Holdings LLC · Miami, FLN233DPProp 2 Fox LLC · Hudson, OHN233EPEpic Aviation Inc · New Smyrna Beach, FLN233FFArq Aviation LLC · Wilmington, NCN233HYTen Mile Ranch Inc · Vale, ORN233JDSulphur Creek Helicopters LLC · Three Rivers, TXN233MMartin Dennis E · Oconto, WIN233MAMidwest Corporate Air Inc · Bellefontaine, OHN233MEEight Ball Flying Club · Van Nuys, CAN233MGFly Safe LLC · Belle Isle, FLN233SFSale Reported · Wakarusa, INSale reportedN233TRPark Industries Inc · Corona, CAN233VVCampbell Scott A · Marseilles, ILN233WMBosco 74 LLC · Wilmington, DEN23407S C Skylane LLC · Cumming, GAN2340CWilliam J Davis · Bismarck, NDN2340TGrillo Donald · Green Cove Springs, FLN2341YFlying G Aviation Inc · Drayton, NDN2343RSkyhawk Aviation LLC · Rutherfordton, NCN2343ULanning Dwight V · Thaxton, VAN2345RBlue Wave Air LLC · Huntsville, ALN23480Pkp Aviation LLC · Alexandria, VAN2348SGeorgia Forestry Commission · Macon, GAN23497Full Throttle Aviation LLC · Clayton, DEN2349RSalser Aviation LLC · Ocala, FLN2349XNorris James A · Export, PAN234AJMullins Land Co Inc · Aiken, SCN234AMMondkar Avinash M · Payson, AZN234ARHague Arsh · Orangeburg, NYN234BAJohnson Alan Lee · Pikeville, KYN234BLSullivan Leo W · O Fallon, ILN234BPYoung Tim M Trustee · Edmond, OKN234CSundquist Steven A · Yakima, WAN234CEAir Arctic Inc · Fairbanks, AKN234CPZan Am LLC · Findlay, OHN234DGSnyder Patrick M · Cortland, NYN234DKKellis Dana S · Farmington, UTN234DLAngel Wings LLC · Waxhaw, NCFirst renewal noticeN234EPEpic Aviation Inc · New Smyrna Beach, FLN234FFAviato I LLC · Palo Alto, CAN234GAAllen Dean C II · Green Sea, SCN234GBChristensen Gary B · Mesa, AZN234HBLentini Christopher · Ardmore, OKN234HUStevens Matthew S · Penn Yan, NY
Back to AD 2006-10-21