Skip to content

Registered aircraft · 4,469

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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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:94-20-04-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.

N7072NDesrosiers Stefan · Scotch Plains, NJBuilt 1967 · S/N D-8648 N7073NOlson Steven E · Lakeville, MNBuilt 1967 · S/N D-8650 N7075NSign Zeppelin LLC · Orlando, FLBuilt 1968 · S/N D-8733 N707BRCawood William Richard · Mountain Rest, SCBuilt 1966 · S/N D-8312 N707CHCharlie Hotel LLC · Madisonville, TNBuilt 1957 · S/N D5294 N707LHoon David M · Wolf Creek, MTBuilt 1968 · S/N D-8731 N707RCFitzpatrick Sturgill Heather L · Edmonds, WAS/N D-5730 N707RDJones Alonzo · Los Angeles, CABuilt 1974 · S/N D-9708 N7082NJasmin Grant Frederick Jr · East Palo Alto, CABuilt 1967 · S/N D-8661 N7083NCollins John D · Charlotte, NCBuilt 1967 · S/N D-8663 N708DForsyth Technical Community College · Winston Salem, NCS/N D-2980 N7096NBoylan Scott J · BerlinBuilt 1967 · S/N D-8662 N70DRLanzillo Joseph H · Lancaster, PABuilt 1979 · S/N D-10224 N70DWEastern Flatlanders LLC · Yuma, COBuilt 1964 · S/N D-7705 N70KTLucarelli Jeffrey M · Summerville, SCFirst renewal noticeBuilt 1953 · S/N D-3480 N70MEAmsdell David A · Morgantown, WVBuilt 1978 · S/N D-10123 N70MVDawson Asset Management And Consulting LLC · Edgartown, MABuilt 1979 · S/N D-10222 N70RAMarabella John · Sarasota, FLBuilt 1965 · S/N D-7819 N70SSJones Terry L · Danville, VABuilt 1966 · S/N D-8024 N7102NDefelice David E · Ponte Vedra Beach, FLBuilt 1967 · S/N D-8667 N7104NGober Kerwin D · Farmington, NMBuilt 1967 · S/N D-8666 N710AMQualitair LLC Trustee · MichelstadtBuilt 1953 · S/N D-3587 N710VMartin James D · Graford, TXBuilt 1959 · S/N D-6135 N7114NPrairie Air Inc · Elbow Lake, MNBuilt 1967 · S/N D-8668 N7116NMook Joshua Tyler · Cincinnati, OHBuilt 1967 · S/N D-8670 N7118Mace Paul B · Ashland, ORBuilt 1957 · S/N D-5099 N711DJPatenaude Steven J · Livermore, CABuilt 1952 · S/N D-3059 N711KMRegistration Pending · Cologne, MNRegistration pendingBuilt 1970 · S/N D-9106 N711LWWhelchel Leon · Vinton, IABuilt 1962 · S/N D-6984 N711NCHussey Aviation LLC · Clear Lake, IAS/N D-9776 N711PAKimball Spruce L · Hampton, GABuilt 1957 · S/N D-5206 N711RBMorris John C III · Rochester, MNBuilt 1969 · S/N D-9015 N711TVRepko Ventures LLC · Logan, UTBuilt 1965 · S/N D-7931 N711XVeetail LLC · Land O Lakes, FLBuilt 1964 · S/N D-7732 N7121NLockbaum Jim · Oconomowoc, WIBuilt 1967 · S/N D-8674 N7124NClifton Fred R Jr · Fredericksburg, TXBuilt 1967 · S/N D-8677 N7128NMartin Automatic Inc · Rockford, ILBuilt 1967 · S/N D-8675 N713MGMy Multifamily Investments LLC · Dallas, TXS/N D-10285 N713TTAbe Air LLC · Salinas, CABuilt 1975 · S/N D-9806 N713WBJohnston William J · New Castle, COBuilt 1962 · S/N D-7074 N7141NSlowikowski Jr Daniel F · Pensacola, FLBuilt 1968 · S/N D-8713 N7145NOklahoma Beech Boys LLC · Weatherford, OKBuilt 2016 · S/N D-8682 N7146NEdmundson George · Hood River, ORBuilt 1968 · S/N D-8680 N7147NHall Michael W · Olivehurst, CABuilt 1967 · S/N D-8681 N7149NLind Dale A · Lewisburg, PABuilt 1968 · S/N D-8686 N714JRShafer Benjamin · Riverside, CABuilt 1964 · S/N D-7504 N7156NDouglas Charles M · Queen Creek, AZBuilt 1968 · S/N D-8687 N7157NPardo Carlos A · Nashville, NCBuilt 1968 · S/N D-8690 N7159NRomeo Bravo Aviation LLC · Russellville, KYBuilt 1968 · S/N D-8814 N715RHAyers Christopher C · San Marcos, CAS/N D-7063

Back to AD 94-20-04 R2