Skip to content

Registered aircraft · 5,102

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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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:81-12-06-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.

N47961Thomas Brian E · Virginia Beach, VABuilt 1977 · S/N 32R-7880029 N4796WHill David E · Ocala, FLBuilt 1976 · S/N 14116 N47977Cossi Restaurant Corp · Ballston Spa, NYBuilt 1977 · S/N 32R-7880031 N4797WMiller Ronald J · Breckenridge, COS/N 14117 N479CBIsland Air LLC · Dover, DEBuilt 1979 · S/N 61P06427963296 N47ER15 East Management Inc · Wake Forest, NCBuilt 2002 · S/N 4636340 N47GHBrennan William · Bethpage, NYBuilt 1969 · S/N 32-40766 N47MMNorstar Aviation LLC · Farmingdale, NYBuilt 1977 · S/N 31-7812036 N47RLUpstate Aircraft Leasing LLC · Wilmington, DEBuilt 1970 · S/N 27-4582 N4804TFord Jesse Harrison · Matthews, NCBuilt 1972 · S/N 32-7240089 N4805WEngberg Randal S · Aledo, TXBuilt 1976 · S/N 14125 N4809WJordan Timothy H · Brookline, NHBuilt 1976 · S/N 14129 N480BLDoctor Blue Eyes LLC · Princeton, WVBuilt 1980 · S/N 32R-8029105 N480RDWings And Things LLC · Wilmington, DEBuilt 1976 · S/N 14127 N4811TDill Mark B · Neosho Rapids, KSS/N 32-7240086 N481TCFargo Aviators LLC · Phoenix, AZBuilt 2002 · S/N T18208184 N481WPoper Jeremy · Albuquerque, NMBuilt 2005 · S/N T18208362 N4824WFmp Properties LLC · Joplin, MOBuilt 1976 · S/N 14154 N4826WRoss Steve M · Marion, ILBuilt 1976 · S/N 14156 N482CGKilo Sierra Enterprises LLC · Lafayette, COBuilt 2005 · S/N T18208438 N482DRThurston Steven Curtis · Salisbury, NCBuilt 1977 · S/N 32R-7780391 N482RPPlane Robert A · Harvard, ILBuilt 1976 · S/N 14155 N4830WCaliguire Michael R · Easton, PABuilt 1976 · S/N 14160 N4832WDaedal Flight LLC · Lancaster, SCBuilt 1976 · S/N 14162 N4837WFields Joseph H · Placerville, CABuilt 1976 · S/N 14167 N4843WMcclean Matthew James · Springfield, MOBuilt 1976 · S/N 14173 N4845FMattern Jeffrey A · Brunswick, OHBuilt 1976 · S/N 32R-7680482 N4846WPrice David · Loudon, TNS/N 14176 N4847WIskin Jeffrey Trustee · Concord, CABuilt 1976 · S/N 14177 N484APDodson International Parts Inc · Rantoul, KSBuilt 1980 · S/N 32-8124003 N4850WWilliams Edward · Hayward, CABuilt 1976 · S/N 14180 N4851FRagland Brady J · Amarillo, TXBuilt 1976 · S/N 32R-7680483 N4855PAvenger Aviation LLC · Midland, TXBuilt 2004 · S/N T18208337 N4856WUhl John W · Sellersburg, INBuilt 1976 · S/N 14186 N4857WShelor Christina L · Virginia Beach, VABuilt 1976 · S/N 14187 N4869BSchaffer Brandon T · Vlg Of Lakewd, ILBuilt 1984 · S/N 32-8424002 N4872SBlocker James Deric · Cave Creek, AZS/N 32-7140054 N4876SLedford Roland S · Borger, TXBuilt 1971 · S/N 32-7140057 N488ATParks Vernon L · Houston, TXBuilt 1991 · S/N 27-0088 N4892SF&G Polk Aviation LLC · Babson Park, FLBuilt 1971 · S/N 32-7140058 N4895WTaylor Mark W · Amherst, NYBuilt 1977 · S/N 14225 N4897WGibson Kurt A · Fort Smith, ARBuilt 1977 · S/N 14227 N48TNWest Thomas L · Payson, AZBuilt 1975 · S/N 60-0214-094 N48YKimble Robert · Marco Island, FLBuilt 1981 · S/N 27-8154022 N4911W3js Aviation LLC · Wilmington, DEBuilt 1977 · S/N 14235 N491JGHartwig Farms LLC · Excelsior Springs, MOBuilt 2001 · S/N T20608265 N4921WForward Aero LLC · Thomasville, PABuilt 1977 · S/N 14245 N4927FRegistered aircraftBuilt 1976 · S/N 32R-7680489 N4928WL D Aviation LLC · Chesapeake, VABuilt 1977 · S/N 14251 N492AGBounds Lee S · Pflugerville, TXS/N 32-40228

Back to AD 81-12-06 R1