Skip to content

Registered aircraft · 22,416

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N7457WNilsson Tim E · Yreka, CABuilt 1963 · S/N 28-1346 N7458JReeves Stephen · Watford City, NDBuilt 1968 · S/N 28R-30810 N7458WMy Bird Is Bigger Than Yours LLC · Fort Myers, FLBuilt 1963 · S/N 28-1347 N7459JEvans Charles Dewayne · Cumby, TXBuilt 1968 · S/N 28R-30811 N745AALarson Stephen Blair · Raleigh, NCBuilt 1968 · S/N 32-40449 N745ATLysenko Aleksandr D · Medford, NJBuilt 1977 · S/N 28R-7703078 N745NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843860 N745PASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881017 N745RAAri Ben Aviator Inc · Fort Pierce, FLBuilt 1990 · S/N 2841327 N7461RIngram John · Tulsa, OKBuilt 1966 · S/N 28-22007 N7461WSdflysc LLC · Mauldin, SCBuilt 1963 · S/N 28-1367 N7462JFirmino Paulo · Gainesville, TXBuilt 1968 · S/N 28R-30814 N7462WResidential Inspection Services Inc · Sun City Center, FLBuilt 1963 · S/N 28-1352 N7463JUnusual Attitudes LLC · Bates City, MOS/N 28R-30815 N7463RBrezina Douglas · Hines, ILS/N 28-22010 N7463WMarschall Travis T · Culver, INBuilt 1963 · S/N 28-1353 N7464WBabcock Wayne N Trustee · Albuquerque, NMS/N 28-1354 N7466WCooper Tracy V · Little Rock, ARS/N 28-1369 N7467JDouble Bridges Aviation · Enterprise, ALBuilt 1968 · S/N 28R-30819 N7467RGee Greg · Los Angeles, CAS/N 28-22015 N7467WPlane Krazy LLC · Edina, MOBuilt 1963 · S/N 28-1370 N7469JSussex Aero Maintenance Inc · Georgetown, DEBuilt 1968 · S/N 28R-30822 N7469WIshii Kanji · Brooklyn, NYBuilt 1963 · S/N 28-1372 N746AJNesta Joseph A · Kelleys Island, OHBuilt 1975 · S/N 32-7540082 N746BCentral Arkansas Flying Club Inc · Bryant, ARBuilt 1974 · S/N 28R-7435187 N746GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881461 N746NDUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 2881489 N746PASkywest Leasing Inc · St George, UTBuilt 2018 · S/N 2881018 N7470JPrairie View Energy LLC · Granite Falls, MNBuilt 1968 · S/N 28R-30823 N7470SNorton Jeffrey N · Greeley, COBuilt 1967 · S/N 28-23624 N7471RBalderas Jose Aaron Jr · Mission, TXBuilt 1966 · S/N 28-22019 N7471VCollins Ronald Rs · Rutledge, TNBuilt 1965 · S/N 28-2284 N7471WRegistered aircraftBuilt 1963 · S/N 28-1376 N7472RSouthern Jeffrey · Rayville, LABuilt 1966 · S/N 28-22021 N7472WTait Ronald M · Fort Worth, TXBuilt 1963 · S/N 28-1377 N7473RSonntag Donald · Marengo, ILFirst renewal noticeBuilt 1966 · S/N 28-22022 N7474JHorton James D · Las Vegas, NVS/N 28R-30827 N7474RGregorski Thomas E · Kenly, NCBuilt 1966 · S/N 28-22023 N7474TWorks James K · Avalon, CABuilt 1967 · S/N 28-23432 N7474WZimmerman Sandra · Henderson, NVBuilt 1963 · S/N 28-1379 N7475RTolsma Garrett J · Kirkland, WABuilt 1966 · S/N 28-22024 N7476JHernandez Miguel A · Brownsville, TXBuilt 1968 · S/N 28R-30831 N7476RCarrillo Jeremiah · Shelton, WABuilt 1966 · S/N 28-22026 N7476WAddison Robert M · Fort Sumner, NMBuilt 1963 · S/N 28-1385 N7477RRegistration Pending · Richmond Hill, GARegistration pendingS/N 28-22028 N7477WBechaver Landon Robert · Mesa, AZBuilt 1963 · S/N 28-1387 N7478JGallo Gerald F · Worcester, MABuilt 1968 · S/N 28R-30834 N7478WTaylor Randall Devlin Trustee · Austin, TXBuilt 1963 · S/N 28-1388 N7479JHouse Nancy L · Sherwood, ARBuilt 1968 · S/N 28R-30835 N7479RDnr Solutions LLC · Idaho Falls, IDS/N 28-22030

Back to AD 87-08-08 R3