Skip to content

Registered aircraft · 56,578

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N22556Rawareo LLC · Warsaw, MOS/N 15068359 N22558Lilik Dennis A · Lewes, DEBuilt 1968 · S/N 15068360 N2255DWeaver Walter J · Concord, NCBuilt 1952 · S/N 20407 N2255EJohnson Steven Allan · Palmer, AKBuilt 1982 · S/N 17275692 N2255XProp & Jet Air Museum Inc · Romoland, CAS/N 337-0155 N22561Buckley Holli R · Columbia, MSBuilt 1968 · S/N 15068362 N22563Davis Michael A Jr · Fairbanks, AKBuilt 1968 · S/N 15068364 N22564Darnell Stephen L · Bargersville, INBuilt 1968 · S/N 15068365 N22568Pina Gabriel B · Pasadena, CABuilt 1968 · S/N 15068368 N2256CCnd Aerospace Ltd · Telluride, COBuilt 1953 · S/N 30556 N2256DRegistered aircraftBuilt 1952 · S/N 20408 N2256XPoole Douglas G · California, MDBuilt 1965 · S/N 337-0156 N22570Nebbia Valter Della · Archer City, TXBuilt 1968 · S/N 15068369 N2257DSmith Ryan M · Greensboro, NCBuilt 1952 · S/N 20409 N22580Carter Benjamin F · Colusa, CABuilt 1976 · S/N 18503076 N22582Lee Scott M · Noble, OKBuilt 1968 · S/N 15068376 N22583Christensen Marc G · Bountiful, UTBuilt 1968 · S/N 15068377 N22584Manning Christopher S · Dawson, GABuilt 1968 · S/N 15068378 N22585Obregon Aviation LLC · San Francisco, CABuilt 1968 · S/N 15068379 N22586Weyker William J · Rhinelander, WIBuilt 1968 · S/N 15068380 N22589Robles Lazaro R · Golden Valley, MNBuilt 1968 · S/N 15068383 N2258SSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1976 · S/N 21061202 N2258TJetage Cutting Tech · Henderson, COBuilt 1968 · S/N 185-1416 N2258YConnor Thomas M · Great Falls, MTBuilt 1967 · S/N 17700058 N2258ZPope Charles A · Sandy Hook, MSBuilt 2007 · S/N 18281937 N22590Sorensen Dale · Wellsville, UTS/N 15068384 N22593State Of Nc · Raleigh, NCS/N 18281938 N22594Morton Eric C · Anchorage, AKBuilt 1968 · S/N 15068388 N22595Johnson Leif M · Midlothian, TXFirst renewal noticeBuilt 1968 · S/N 15068389 N22596Anderson Bradley P · Rapid City, SDBuilt 1968 · S/N 15068390 N22597Mcmanus Charles D · Cottageville, SCBuilt 1968 · S/N 15068391 N22598Dimler Travis M · Alpine, TXBuilt 1974 · S/N 17264071 N2259MHillabrand James E · Rogers, ARBuilt 1975 · S/N 15077090 N2259RLarson Lianne N · Irvine, CABuilt 1968 · S/N T210-0409 N2259SFaireyfam Aviation LLC · Saint George, UTBuilt 1976 · S/N 21061203 N225ANCalifornia In Nice Inc · San Jose, CABuilt 1986 · S/N 17276615 N225EAArellano Erick · Brownsville, TXBuilt 2024 · S/N 18283273 N225FAMcclure Nicholas W · Midland, TXBuilt 2003 · S/N 18281252 N225FRDi Donato Michael · Celina, TXBuilt 1980 · S/N 17273947 N225JSAircraft Holdings LLC · Edmond, OKS/N 17274385 N225KCJr Imaging Logistics Inc · Pasco, WABuilt 1969 · S/N 15070197 N225MGandiaga Philip John · Buhl, IDBuilt 1960 · S/N 52996 N225MHMissall Zoe S · Ontario, NYBuilt 1974 · S/N 17263156 N225MJOsterhout Fred · Sedro Woolley, WABuilt 1964 · S/N 17250609 N225RARochester Air Center LLC · Canandaigua, NYBuilt 2005 · S/N 172S9803 N225SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13441 N225TCameron Mark · Big Arm, MTBuilt 1969 · S/N 18259960 N225TFTop Flight Aviation Inc · Corona, CABuilt 2004 · S/N 172S9755 N225TXCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N 18266946 N225WCBozeman Skyhawk LLC · Bozeman, MTBuilt 2006 · S/N 172S10272

Back to AD 79-10-14 R1