Skip to content

Registered aircraft · 20,683

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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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:90-06-03-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.

N1667FVarner Properties LLC · Bristow, OKBuilt 1966 · S/N 17255062 N1668CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11758 N166CSAtp Aircraft 7 LLC · Wilmington, DEBuilt 2016 · S/N 172S11664 N1670FTillamook Pilots Association · Tillamook, ORBuilt 1966 · S/N 17255065 N1670YMarshall Gregory A · Sauk Rapids, MNBuilt 1962 · S/N 17249370 N1671CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11759 N1671YDavid Dahl · Shevlin, MNBuilt 1962 · S/N 17249371 N1672CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11760 N1672EWichita Area Technical College · Wichita, KSBuilt 1978 · S/N 17271089 N1672YSmith David W · Texarkana, TXBuilt 1962 · S/N 17249372 N1673CCe-172 Aircraft LLC · Wilmington, DEBuilt 2012 · S/N 172S11761 N1673EHusband Thomas W · Bigfork, MTBuilt 1978 · S/N 17271090 N1673FHopkins Ronald J · Salt Lake City, UTFirst renewal noticeBuilt 1966 · S/N 17255068 N1673YLentz Gregory · Green Forest, ARBuilt 1962 · S/N 17249373 N1674EMedary Aviation LLC · Brookings, SDBuilt 2005 · S/N 172S9915 N1674FPlane Nuts Aviation LLC · Livingston, LABuilt 1966 · S/N 17255069 N1674VAbraham Elizabeth J · Browntown, WIBuilt 1974 · S/N 17263709 N1676CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11762 N1676FBrunson Tim R · Gilmer, TXS/N 17255071 N1676YGray Bryan · Colorado City, TXBuilt 1962 · S/N 17249376 N16789Smith Stephen · Annandale, VABuilt 2005 · S/N 172S9916 N1678CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11763 N1678FHorne William D II · Oxford, MSBuilt 1966 · S/N 17255073 N1679FCrawford Anthony B · Hampton Cove, ALBuilt 1966 · S/N 17255074 N167BHHolliday Robert R · Andover, KSBuilt 1966 · S/N 17255345 N167CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N 172S12500 N167SJAbove And Beyond Aviation LLC · Austin, TXBuilt 1997 · S/N 17280167 N167UDLima 001 LLC · Muscatine, IABuilt 2003 · S/N 17281188 N1680FBoyette Robert Wayne · Ashford, ALBuilt 1966 · S/N 17255075 N1681FRegistered aircraftBuilt 1966 · S/N 17255076 N1682FBravo Zak Air LLC · Lake Wales, FLBuilt 1966 · S/N 17255077 N1682YStorby Steven R · Osceola, WIBuilt 1962 · S/N 17249382 N1683CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11764 N1683YKnutson Daniel T · Lodi, WIBuilt 1962 · S/N 17249383 N1684FRedmon Robert J · Gallatin, TNBuilt 1966 · S/N 17255079 N1684YKoenig William J · Benedict, MDS/N 17249384 N1686ELiddick Terry S · Spearfish, SDBuilt 1978 · S/N 17271093 N1686FAdams Claude T Jr · Palmer, AKBuilt 1966 · S/N 17255081 N1686YBrissel John M · El Paso, TXBuilt 1962 · S/N 17249386 N1687CCe-172 Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 172S11731 N1687FTigerair 2020 LLC · Newark, DES/N 17255082 N1688CAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 172S10612 N1688ERegistered aircraftFirst renewal noticeBuilt 1978 · S/N 17271095 N1688FSkydive Spi LLC · South Padre Island, TXBuilt 1966 · S/N 17255083 N1688LHeavy Metal Air LLC · Farmingdale, NYS/N 172S10613 N1688VAvstem Incorporated · Mc Grath, AKBuilt 1974 · S/N 17263714 N16894Saz Dynamics LLC · Daly City, CABuilt 2007 · S/N 172S10615 N16895Luxair LLC · College Station, TXBuilt 2007 · S/N 172S10618 N168CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13068 N168CBLogan Air Services LLC · Logan, UTBuilt 2002 · S/N 172S9119

Back to AD 90-06-03 R1