Skip to content

Registered aircraft · 1,406

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

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:95-26-16-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-16-R1') ORDER BY n_number

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:95-26-16-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-16-R1')
  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:95-26-16-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:95-26-16-R1')
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.

N4599HBlake Larry Q · Suwanee, GABuilt 1979 · S/N 24-0857 N459RBSkydive Mississippi LLC · Jackson, MSS/N 24-1585 N45RHMacfadden & Sons Inc · Sharon Springs, NYBuilt 1994 · S/N 24-3344 N4624HDavis Jeffrey M · Palm Beach Gardens, FLBuilt 1979 · S/N 24-0902 N4626HFlying K Enterprises LLC · Midvale, UTBuilt 1979 · S/N 24-0799 N4644HBentley William C · Lafayette, LABuilt 1979 · S/N 24-0823 N4665HWinrick LLC · Flagstaff, AZBuilt 1979 · S/N 24-0803 N4667HAmazn Leasn Inc · Lees Summit, MOBuilt 1979 · S/N 24-0845 N4668HSanchez Diaz Elias · Morrisville, NCBuilt 1979 · S/N 24-0805 N4671HHall James F · San Luis Obispo, CABuilt 1979 · S/N 24-0806 N4672HSmith Alyssa D · Eagan, MNS/N 24-0807 N4679HAdams Kris · Griffin, GABuilt 1979 · S/N 24-0808 N468SLd Funding LLC · Piscataway, NJBuilt 1994 · S/N 243324 N468WPerson Matt · Denton, NEBuilt 1978 · S/N 24-0404 N4690HCozzolino Richard A · Hamden, CTBuilt 1979 · S/N 24-0809 N4700HRegistered aircraftBuilt 1979 · S/N 24-0825 N4702HAbove All Others Consulting Inc · West Palm Beach, FLBuilt 1979 · S/N 24-0812 N4717HLinder Marlin D · Morrison, COBuilt 1979 · S/N 24-0819 N4719HGanim Rose · Haydenville, MABuilt 1979 · S/N 24-0821 N4722PEac Property Management LLC · Atlanta, GAS/N 240245 N4730HMoore Performance Aircraft LLC · Jenks, OKBuilt 1979 · S/N 24-0827 N4738HBravo Tango Properties LLC · Gahanna, OHBuilt 1979 · S/N 24-0831 N4739HDwyer James F · Denver, COBuilt 1979 · S/N 24-0832 N4746HEdenburn Douglas Lindley · Concord, NCBuilt 1979 · S/N 24-0833 N474DCPopescu Marian · Pensacola, FLS/N 24-1623 N4760HBrh Aviation Inc · Indianapolis, INBuilt 1979 · S/N 24-0839 N4766HHay Christopher C · Sweet Home, ORBuilt 1979 · S/N 24-0843 N4769HRoark Ken W · Cisco, TXBuilt 1979 · S/N 24-0863 N4772HBymers Gary E · Waunakee, WIBuilt 1979 · S/N 24-0865 N4773HPapa Ks Flying Service LLC · Centerville, IABuilt 1979 · S/N 24-0866 N4774HBillstrand Thomas A · Memphis, TNBuilt 1979 · S/N 24-0867 N4775HMile 13 Airplane LLC · West Hartford, CTBuilt 1979 · S/N 24-0868 N4786HRaines Charles G · Camarillo, CABuilt 1979 · S/N 24-0876 N4789HChambers Kenneth G Trustee · Los Gatos, CABuilt 1979 · S/N 24-0879 N4791HMooney 201 LLC · Auburndale, FLBuilt 1979 · S/N 24-0881 N4792HBayview Aircraft LLC · Simpsonville, SCS/N 24-0882 N47FMTake Wing Leasing LLC · Quakertown, PABuilt 1998 · S/N 24-3424 N4804HMcdavid Bourke D Jr · Crestview, FLBuilt 1979 · S/N 24-0886 N4815HWillis Bobby B · Mckinney, TXBuilt 1979 · S/N 24-0888 N4826HIrvin Roy A · Summerville, SCFirst renewal noticeBuilt 1979 · S/N 24-0890 N48FMAvworth Aviation Consulting Inc · Florence, KYBuilt 1998 · S/N 24-3428 N48GTBel Air Resources Inc · Bellingham, WABuilt 1994 · S/N 24-3327 N494RMMatalqa Tareq R · Gahanna, OHBuilt 1984 · S/N 24-1516 N495CBHillsberry Daniel A · Jacksonville, FLS/N 24-3272 N497RRegistered aircraftS/N 24-3080 N49GHRegistered aircraftBuilt 1994 · S/N 24-3328 N4MLSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1997 · S/N 24-3400 N4WYParriott Eric T · Tarzana, CABuilt 1982 · S/N 24-1351 N500WSKns Asset Management LLC · Lumberton, TXS/N 24-0217 N50HLHerlth Clifford A · Cameron Park, CABuilt 1979 · S/N 24-0931

Back to AD 95-26-16 R1