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.

N2432KChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280870 N24334Sorbi Aviation Inc · El Cajon, CABuilt 2000 · S/N 17280887 N24336Moody Bible Institute Of Chicago · Spokane, WABuilt 2000 · S/N 17280888 N2433SN2433s LLC · Manassas, VABuilt 2000 · S/N 17280872 N2433YWheeler Dean S · Lebanon, ORS/N 17249733 N2434LWeston Torey C · Unionville, MOBuilt 1966 · S/N 17255634 N2434USkyhawk N2434u LLC · Wilmington, DEBuilt 1963 · S/N 17250034 N24350Aero Equities LLC · Ventura, CABuilt 2006 · S/N 172S10144 N24352National Training I LLC · Wilmington, DEBuilt 2000 · S/N 17280835 N2435LAero Science International LLC · Augusta, GABuilt 1966 · S/N 17255635 N2435UGalati Stephen E · Florissant, MOBuilt 1963 · S/N 17250035 N2436NThunderbird Aviation · Bloomington, MNBuilt 2000 · S/N 17280842 N2436WThunderbird Aviation · Bloomington, MNFirst renewal noticeBuilt 2000 · S/N 17280841 N2437YRussell John D · Dana Point, CABuilt 1962 · S/N 17249737 N2438ERainier Flight Service LLC · Renton, WABuilt 2000 · S/N 17280878 N2438SMid-Island Air Service Inc · Ronkonkoma, NYFirst renewal noticeBuilt 2000 · S/N 17280875 N2438UThweatt Greg K · Lodi, CABuilt 1963 · S/N 17250038 N2438YHoskins Aaron C · Cayuga, NYBuilt 1962 · S/N 17249738 N2439LBetts William B · Big Lake, AKS/N 17255639 N2439USmith Steven T · Charlottesville, VABuilt 1963 · S/N 17250039 N2439YBluegate Engineering LLC · Richburg, SCBuilt 1962 · S/N 17249739 N2439ZPlane Nonsense Inc · Middletown, DEBuilt 2007 · S/N 172S10564 N243AURunamuck LLC · New Orleans, LABuilt 2024 · S/N 172S13223 N243CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12338 N243EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2025 · S/N 172S13281 N243HAAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11583 N243RLAtp Aircraft 8 LLC · Wilmington, DEBuilt 2015 · S/N 172S11595 N243SPBarbers Point Flight School LLC · Kapolei, HIBuilt 1999 · S/N 172S8212 N243WMoore William · Dalhart, TXBuilt 1971 · S/N 17260205 N2440LEads Kevin C · Arley, ALBuilt 1966 · S/N 17255640 N2440UMiller Patrick · Madison, MNBuilt 1963 · S/N 17250040 N2440YMorristown Flying Service Inc · Talbott, TNBuilt 1962 · S/N 17249740 N2441DKsm Aviation Inc · Wilmington, DEBuilt 2000 · S/N 17280983 N2441EMyf Holdings LLC · San Diego, CABuilt 2000 · S/N 17280879 N2442EExecutive Flyers Inc · Sacramento, CABuilt 1978 · S/N 17271285 N2442LPratt Mark R · La Grande, ORBuilt 1966 · S/N 17255642 N2443LOdlozil Henry W · Ennis, TXBuilt 1966 · S/N 17255643 N2443UIntream Companies LLC · Perryville, MOBuilt 1963 · S/N 17250043 N24447Mustang Sally Aviation LLC · Camden, SCBuilt 2006 · S/N 172S10122 N2444HChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280874 N2444YConrad Matthew J · Dardenne Prairie, MOBuilt 1962 · S/N 17249744 N2445UPeachey Jason J · Milroy, PABuilt 1963 · S/N 17250045 N2445YNew England Aircraft Detailing LLC · Webster, MAS/N 17249745 N2446YMcmickle Edward R · Riverside, CAS/N 17249746 N2446ZEdb Air Inc · Wilsonville, ORBuilt 2006 · S/N 172S10118 N2447BSilver Express Co · Miami, FLBuilt 1999 · S/N 17280801 N2447DAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280803 N2447UMccauley Stephen M · Buckley, WAS/N 17250047 N2447YNeu Aviation LLC · Benton, LABuilt 1962 · S/N 17249747 N24483Fly 172r LLC · Peoria, AZBuilt 2000 · S/N 17280982

Back to AD 90-06-03 R1