Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N736KERegistration Pending · Cozad, NERegistration pendingBuilt 1977 · S/N R1722581 N736KFEason Richard O · Orono, MEBuilt 1977 · S/N R1722582 N736KNTurbine Financial Group LLC · Ogden, UTBuilt 1977 · S/N R1722589 N736KPSutton Aircraft Salvage LLC · Palmer, AKS/N R1722590 N736KSRigfuel LLC · Eureka, MTS/N R1722593 N736KYSicheneder Scott A · Wasilla, AKBuilt 1977 · S/N R1722599 N736LBSkyraider Aero Club · Spokane, WABuilt 1972 · S/N 17701825 N736LDSteinmeyer Peter A · Arvada, COBuilt 1977 · S/N R1722604 N736LFAvitran Inc · Coral Gables, FLBuilt 1978 · S/N R18200738 N736LGM & R Aviation LLC · Fairview, ORBuilt 1977 · S/N R1722607 N736LHDdjrrm Enterprises LLC · Plainfield, INBuilt 1977 · S/N R1722608 N736LLSmith Matthew R · Thomaston, GAS/N R1722611 N736LMRaducu Radu · Bismarck, NDBuilt 1977 · S/N R1722612 N736LPAlpha Kilo Aviation LLC · Wasilla, AKBuilt 1977 · S/N R1722614 N736LVEggleston Kenneth W · Bethel, AKBuilt 1977 · S/N R1722620 N736LWDrr Boonville LLC · Boonville, NYBuilt 1977 · S/N R1722621 N736LXTaylor Tom M · Tulsa, OKBuilt 1977 · S/N R1722622 N736MC3 Pandas LLC · Farmington, NMBuilt 1977 · S/N R1722626 N736MDBrown Tyler Cooper Trustee · Anchorage, AKBuilt 1977 · S/N R1722627 N736MFTurnagain Airventures LLC · Anchorage, AKBuilt 1977 · S/N R1722629 N736MJClover Park Technical College · Lakewood, WABuilt 1979 · S/N R18200741 N736MKDavis Rodger C · Anchorage, AKBuilt 1977 · S/N R1722633 N736MLH & L Acquisitions LLC · Flushing, MIBuilt 1977 · S/N R1722634 N736MNSeidler Matthew J · Anchorage, AKBuilt 1977 · S/N R1722635 N736MPDarby Air Ltd · Lincolnshire, ILBuilt 1977 · S/N R1722636 N736MTLowe John H · Tifton, GABuilt 1977 · S/N R1722640 N736MVMyers Aviation Inc · Oshkosh, WIS/N R1722642 N736MWWestern Radio Services Co · Prineville, ORBuilt 1977 · S/N R1722643 N736MYLandry Cheryl A · Mendon, MABuilt 1977 · S/N R1722645 N736NCGully Justin T · Anoka, MNS/N R1722649 N736NEMahoney Daniel P III · Locust Grove, VABuilt 1977 · S/N R1722651 N736NFFhr Inc · Honolulu, HIBuilt 1977 · S/N R1722652 N736NGCatcu Aviation LLC · Edinburg, TXBuilt 1978 · S/N R18200745 N736NHCi Aviation LLC · Broadview Heights, OHBuilt 1977 · S/N R1722654 N736NJCarr Gary A · Rittman, OHBuilt 1978 · S/N R18200746 N736NKMaine Air Physician Services LLC · Machias, MEBuilt 1977 · S/N R1722656 N736NNM2 Aviation LLC · White Lake, MIBuilt 1977 · S/N R1722659 N736NPMbn Leasing LLC · Dover, DEBuilt 1977 · S/N R1722660 N736NQAs In The Key Aviation LLC · Marathon, FLBuilt 1977 · S/N R1722661 N736NWG Force LLC · Las Vegas, NVBuilt 1977 · S/N R1722667 N736NYTerry Mark Benjamin · Henderson, NCBuilt 1977 · S/N R1722669 N736NZColey Steven J · Baker City, ORBuilt 1977 · S/N R1722670 N736PBWoods Joyce M Trustee · Albuquerque, NMBuilt 1977 · S/N R1722671 N736PCMoore Glen O · Carson City, NVBuilt 1977 · S/N R1722672 N736PDMiner'S Outdoor Adventures LLC · Hermantown, MNBuilt 1977 · S/N R1722673 N736PEBohannon Ronald D · Newburgh, INBuilt 1977 · S/N R1722674 N736PHReynolds Thomas J · Dillon, MTBuilt 1977 · S/N R1722677 N736PKA&R In The Clouds LLC · Myrtle Beach, SCBuilt 1977 · S/N R1722679 N736PLSims Charles R Jr · Tuscumbia, ALS/N R1722680 N736PMBennett James P · Milford, DEBuilt 1977 · S/N R1722681

Back to AD 87-20-03 R2