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.

N7287PTwo Dot Aircraft LLC · Kalispell, MTBuilt 1961 · S/N 24-2465 N7288YN7288y LLC · Manassas, VABuilt 1964 · S/N 30-326 N728KAptum Aviation Inc · Hicksville, NYS/N 34-7670132 N7290PFarmland Investments Inc · Mound City, MOBuilt 1961 · S/N 24-2468 N7294YTgaap Inc · Dover, DEBuilt 1964 · S/N 30-333 N72DNPostiglione Daniel · West Babylon, NYBuilt 1971 · S/N 24-5006 N72MWStaggs Austin · Cudjoe Key, FLBuilt 1963 · S/N 30-171 N72RJEngerer Dennis E · Northville, MIBuilt 1968 · S/N 28R-30891 N72SB72 Sierra Bravo LLC · Allegany, NYBuilt 1971 · S/N 24-4969 N7300YAdriatic Holdings LLC · Cheyenne, WYBuilt 1964 · S/N 30-341 N7302YJohnson Robert Daniel · Seabrook, TXBuilt 1964 · S/N 30-345 N7303PWeisend Chad · Peru, INBuilt 1961 · S/N 24-2478 N7304YN3024d LLC · Reno, NVBuilt 1964 · S/N 30-349 N7305YRegistered aircraftBuilt 1964 · S/N 30-350 N7309PEvergreen Underground Water Conservation District · Pleasanton, TXS/N 24-2484 N7309YGlaser William Burnett · New Smyrna Beach, FLS/N 30-296 N730XSbh Alliance LLC · Sauk Rapids, MNBuilt 2002 · S/N 2844066 N7311YInternational Air Services Inc Trustee · Carson City, NVBuilt 1964 · S/N 30-354 N7313YPr Aeronautics LLC · Buffalo, SDBuilt 1964 · S/N 30-356 N7316PCase Mark A Trustee · Shady Shores, TXBuilt 1961 · S/N 24-2492 N7317YComanche Air Services LLC · Westminster, COBuilt 1964 · S/N 30-360 N7318YBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 30-361 N731WN64gs LLC · Van Nuys, CABuilt 1971 · S/N 24-4989 N731WAA S Flight Academy LLC · Lantana, FLBuilt 1973 · S/N 347350245 N7320YSpruce John P · Liberty Hill, TXBuilt 1964 · S/N 30-364 N7321PTappan East LLC · New Philadelphia, OHBuilt 1961 · S/N 24-2498 N7322PRuple Michael D · Palm Bay, FLBuilt 1961 · S/N 24-2499 N7323PDurham Damon Patrick · Ripley, TNBuilt 1961 · S/N 24-2500 N7323YFoster Jay W · Marshfield, MOBuilt 1964 · S/N 30-367 N7324PWright Havis L · Pleasant Hill, MOBuilt 1961 · S/N 24-2502 N7324YMccaslin Dale Alan Trustee · Holt, MOBuilt 1964 · S/N 30-369 N7326PHarris David M · Costa Mesa, CABuilt 1961 · S/N 24-2504 N7326YHighsky Aero Inc · Arlington, TXBuilt 1964 · S/N 30-371 N7327PTown Terry N · Lake Havasu City, AZBuilt 1961 · S/N 24-2505 N7327YGeyman Edward J · Wilmington, OHBuilt 1964 · S/N 30-372 N7328PCoffee Bean Connoisseur LLC · Highland, NYBuilt 1961 · S/N 24-2506 N7328YBarnett David K · Brock, TXS/N 30-374 N7329PSlm Holdings LLC · Kalispell, MTBuilt 1961 · S/N 24-2507 N732CATrey Stroup Aviation LLC · Fort Pierre, SDBuilt 1966 · S/N 30-1086 N7330PGenpack LLC · Hillsdale, NJBuilt 1961 · S/N 24-2509 N7330YJordan Terry L · Hugoton, KSBuilt 1964 · S/N 30-378 N7331YNeubert Erich S · Dana Point, CABuilt 1964 · S/N 30-292 N7332PArnold Christian M · Waltham, MABuilt 1961 · S/N 24-2511 N7334YJg Air LLC · Cape Coral, FLBuilt 1964 · S/N 30-383 N7338PPope Kent M · Hayden, IDBuilt 1961 · S/N 24-2517 N733GPHorton Luther · Lakeland, FLBuilt 1962 · S/N 24-3213 N7340PWard James A · Brentwood, TNBuilt 1961 · S/N 24-2519 N7341PBlaes Richard S · Columbus, OHBuilt 1960 · S/N 24-2520 N7342YHinkle Anthony · Mineola, TXBuilt 1964 · S/N 30-392 N7344PWorley Jimmy · Dallas, TXBuilt 1961 · S/N 24-2522

Back to AD 97-01-01 R1