Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N7606CKuuluka LLC · Lewes, DEBuilt 1975 · S/N 32R-7680048 N7606JLiburd Edison V · Austell, GABuilt 1968 · S/N 28R-30920 N7607JMoser Robert W · Flower Mound, TXBuilt 1968 · S/N 28R-30936 N7608JGevry Ronald Joseph Jr · Alpharetta, GABuilt 1968 · S/N 28R-30999 N7608YJohnson Craig · Moreland, GAS/N 30-679 N7609CBergstrom Aircraft Inc · Pasco, WABuilt 1976 · S/N 34-7670097 N7609JMcmaster William Timothy · Hanford, CABuilt 1968 · S/N 28R-31001 N7609YDowning Gregg R · Guymon, OKBuilt 1964 · S/N 30-680 N760FSModi Yogini · Homestead, FLBuilt 1972 · S/N 34-7250213 N760PSEagle Squadron Inc · The Villages, FLBuilt 1976 · S/N 32R-7680342 N7610JDelci Dino J · Tempe, AZBuilt 1968 · S/N 28R-31002 N7610PMorris Scott R · Steilacoom, WABuilt 1961 · S/N 24-2821 N7611PChamberlain Paul E · Troup, TXBuilt 1961 · S/N 24-2822 N7611YRandall Dean A · Reno, NVS/N 30-683 N7612JSpeer Aviation LLC · Live Oak, FLBuilt 1968 · S/N 28R-30801 N7613PSimpson Randolph L · Shelburne Falls, MABuilt 1961 · S/N 24-2824 N7614JN7614j LLC · Berkeley Heights, NJBuilt 1968 · S/N 28R-31006 N7614YSky Walker Flight School LLC · Adrian, MIBuilt 1964 · S/N 30-687 N7615JAll American Aviation Services Inc · Fayetteville, NCBuilt 1968 · S/N 28R-31008 N7615PFly High Ventures LLC · Chester, VABuilt 1961 · S/N 24-2826 N7616JThigpen Kevin · Jacksonville, FLBuilt 1968 · S/N 28R-31009 N7616PNelson Peter T · Ghent, NYBuilt 1961 · S/N 24-2827 N7617JMilner Quinn D · Carbondale, ILBuilt 1968 · S/N 28R-31010 N7617PSlack Don S · Stinson Beach, CABuilt 1961 · S/N 24-2828 N7618PJaton Bertrand F · Woodville, TXBuilt 1961 · S/N 24-2829 N7619PFirst Class Auto Remarketing LLC · Lehigh Acres, FLS/N 24-2830 N761DBOne Two Air LLC · Traverse City, MIBuilt 1978 · S/N 34-7970014 N7621EGrey Matter Inc · Valley Springs, CAS/N 24-2168 N7621PMckusick Eileen D · Winooski, VTBuilt 1961 · S/N 24-2832 N7622FAeronation Aircraft & Exotics LLC · Lewes, DES/N 32R-7780065 N7622JSkylink Aviation Inc · Florissant, MOBuilt 1968 · S/N 28R-31017 N7623JWhite Jeffrey M · Carlsbad, CAS/N 28R-31018 N7624JBriggano LLC · Mount Pleasant, SCBuilt 1969 · S/N 28R-31102 N7625JHuebscher Attila · Flemington, NJBuilt 1968 · S/N 28R-31020 N7625PVfr2imc LLC · Elko, NVBuilt 1961 · S/N 24-2836 N7626PZervos Fredric W · Orland Park, ILBuilt 1961 · S/N 24-2548 N7626YAdamson Matthew C · Sherwood, ARFirst renewal noticeS/N 30-700 N7627DVanhouse Daniel W · Topeka, KSBuilt 1969 · S/N 28R-35055 N7627PKill Stephen W · Granbury, TXBuilt 1961 · S/N 24-2837 N7628YLamantia Mark V · Ebensburg, PABuilt 1964 · S/N 30-703 N7629JWatson Tony A · Rydal, GABuilt 1969 · S/N 28R-31024 N7630YJprg Aviation Inc · Orlando, FLBuilt 1964 · S/N 30-706 N7631YMbsp Enterprises Inc · Wilmington, DEBuilt 1965 · S/N 30-707 N7632YLee Kitchell · Shelburne Falls, MAS/N 30-709 N7633YMatt Younkin Airshows Inc · Siloam Springs, ARBuilt 1965 · S/N 30-710 N7634JSullivan Wade M · Mukilteo, WABuilt 1968 · S/N 28R-31030 N7634PDykema Carl F · Davie, FLBuilt 1961 · S/N 24-2846 N7635JBecker Riley · Transylvania, LABuilt 1969 · S/N 28R-31032 N7637JMartin Kevin H · Selbyville, DEBuilt 1968 · S/N 28R-31036 N7637PFyi Adventures LLC · Ocala, FLBuilt 1962 · S/N 24-2849

Back to AD 97-01-01 R1