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.

N3052U6m Aviation LLC · Pleasant Hill, MOBuilt 1963 · S/N 17250652 N3053UJ & T Aviation LLC · Nashua, NHBuilt 1963 · S/N 17250653 N3054EPrinceton Flying Club Inc · Wilmington, DEBuilt 1978 · S/N 17271421 N3056USchans Richard L Sr · New Bern, NCBuilt 1963 · S/N 17250656 N30579Dry Creek Services LLC · Lodi, OHBuilt 1974 · S/N 17264145 N3057UDesousa Raphael · Fremont, CABuilt 1963 · S/N 17250657 N305ACTascosa Trail Inc · Gruver, TXBuilt 1965 · S/N 17253679 N305CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11532 N305FGRidgeline Assets LLC · Wilmington, DES/N 172S13274 N305PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264131 N305RSElite Approach LLC · Chesterfield, MOBuilt 2001 · S/N 172S8834 N305TXCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13227 N305XXDs Group LLC · Miami, FLBuilt 1975 · S/N 17265513 N3060UWhipple James M · Wadsworth, OHBuilt 1963 · S/N 17250660 N30617Executive Flight Training & Services LLC · Sanford, NCBuilt 1974 · S/N 17264149 N3061UWade William J · Waterman, ILS/N 17250661 N3062UMitchell Steven C · Knoxville, IABuilt 1963 · S/N 17250662 N3063ULittle Bird Airways LLC · Hamburg, NYBuilt 1963 · S/N 17250663 N30643Hurst Gordon · Waterford, PABuilt 1974 · S/N 17264150 N3064UMcintosh Randall W · Rome City, INBuilt 1963 · S/N 17250664 N3065E3065e LLC · Westfield, PABuilt 1978 · S/N 17271425 N3068UArlins Aircraft Service Inc · Belgrade, MTBuilt 1963 · S/N 17250668 N306CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13082 N306DPHer Airway LLC · Boca Grande, FLBuilt 2016 · S/N 172S11736 N306GWCollege Of Missionary Aviation Inc · Keystone Heights, FLS/N 17250714 N306HBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12968 N306PPSl Aviation LLC · Seattle, WABuilt 2010 · S/N 172S11042 N3071URegistration Pending · Sheridan, WYRegistration pendingBuilt 1963 · S/N 17250671 N3072EReed Michael A Trustee · Minerva, OHBuilt 1978 · S/N 17271428 N3076EHinkes Kenny · Albuquerque, NMBuilt 1978 · S/N 17271430 N3077EBlackhawk Holding Corp · Wilmington, DEBuilt 1978 · S/N 17271431 N307BMBow Mac Aviation LLC · Spring Lake, MIBuilt 1973 · S/N 17262450 N307BZSummit Aviation Inc · Belgrade, MTBuilt 2003 · S/N 172S9486 N307CREmpire Of Stars Commercial And Residential Real · Downey, CAS/N 17262385 N307GHollister Jet Center Inc · Hollister, CABuilt 1974 · S/N 17263007 N307KMMcphaill Kevin · Visalia, CABuilt 1963 · S/N 17250381 N307SPSheridan Pilots 307 LLC · Sheridan, WYBuilt 1979 · S/N 17273438 N3080ESky Safety Inc · San Antonio, TXBuilt 1978 · S/N 17271433 N3082EAirgo Inc · Centralia, ILFirst renewal noticeBuilt 1978 · S/N 17271435 N3082UArmstrong Geoffrey Peter · Las Vegas, NVBuilt 1963 · S/N 17250682 N3085UMoyers Tim J · Clovis, NMBuilt 1963 · S/N 17250685 N3086EMcclurkin David A · Norman, OKBuilt 1978 · S/N 17271436 N3086SAmo Air & Claims LLC · Grove, OKS/N 17256700 N3087UShelite Michael J · Enid, OKS/N 17250687 N308SPAmeriflyers Of Texas Inc · Addison, TXBuilt 2003 · S/N 172S9487 N308SUHagele Aviation LLC · Hillsboro, ORBuilt 1981 · S/N 17275027 N3093EBrown Joseph M · Kansas City, MOBuilt 1978 · S/N 17271440 N3093UEfflandt Joseph E · Eagle, IDBuilt 1963 · S/N 17250693 N3096UDyer Gerald W · Arlington, TXS/N 17250696 N3098UHogan Lee · Addison, ILBuilt 1963 · S/N 17250698

Back to AD 90-06-03 R1