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.

N3277LDeshpande Peter N · Eugene, ORBuilt 1967 · S/N 17256177 N3278LPeterson Donald A · Ajo, AZBuilt 1967 · S/N 17256178 N3279LDomnarski Michael J · Ware, MABuilt 1967 · S/N 17256179 N327SPAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8254 N3280LDobbertin Thomas E · Redlands, CAS/N 17256180 N3281LWizna LLC · Boca Raton, FLBuilt 1967 · S/N 17256181 N3282LFranco David F Jr · Santa Rosa, CABuilt 1967 · S/N 17256182 N3283LHill Suzanne L · Edmond, OKBuilt 1967 · S/N 17256183 N3284LWill Clifford S · Grayson, GABuilt 1967 · S/N 17256184 N3285LDouglass Grant · Rockport, TXBuilt 1967 · S/N 17256185 N3286LEagle Eye Aviation LLC · Meridian, IDBuilt 1967 · S/N 17256186 N3287EOff Course Aero Ventures LLC · Mechanicsville, VABuilt 1978 · S/N 17271492 N3288Mewmew Investment II LLC · Palo Alto, CABuilt 2020 · S/N 172S12430 N328DDLandsburg Custom Services LLC · Sandusky, MIBuilt 1973 · S/N 17262401 N328FAAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13220 N328MEFlying Start Aero Services LLC · Reno, NVS/N 172S8575 N328TASuburban Air Corp · Castro Valley, CABuilt 2003 · S/N 172S9328 N3291EKukuchka Ronald G · Tunkhannock, PABuilt 1978 · S/N 17271493 N3291LSun Baron · Arcadia, CABuilt 1967 · S/N 17256191 N3297LRaymond Patrick H · Jerseyville, ILBuilt 1967 · S/N 17256197 N3298LThompson Edward E · Buxton, MEBuilt 1967 · S/N 17256198 N3299EBeglin Bruce W · Oxford, MDBuilt 1978 · S/N 17271495 N3299LHarrington David J · Albuquerque, NMBuilt 1967 · S/N 17256199 N329JFJ F Aviation Inc · Joliet, ILBuilt 1975 · S/N 17265835 N329MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8461 N32BEWisecup Wilbur V Jr · Germantown, OHBuilt 1974 · S/N 17263249 N32GVEastern Cincinnati Aviation Inc · Batavia, OHS/N 17267026 N32LACircle S Aviation LLC · Starkville, MSBuilt 1972 · S/N 17260454 N32MPAshford Aviation Inc · Dothan, ALBuilt 1981 · S/N 172RG1019 N32YAFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1980 · S/N 17273862 N3306EBlackwell Calvin C · Fort Worth, TXBuilt 1978 · S/N 17271498 N330JEWings Over Texas Holdings LLC · Denton, TXBuilt 1997 · S/N 17280299 N330MEUnique Educational Experiences · Signal Hill, CABuilt 2000 · S/N 172S8462 N330PMPractical Education LLC · New York, NYBuilt 2008 · S/N 172S10809 N3314EEnglund Frances L · Fairport, NYBuilt 1978 · S/N 17271500 N3315EBas Part Sales LLC · Greeley, COS/N 17271501 N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502 N331CHCh Wings LLC · Arvada, COBuilt 2022 · S/N 172S12917 N331CPCivil Air Patrol · Montgomery, ALBuilt 2019 · S/N 172S12342 N331JKKenzy 2020 LLC · Aurora, ORBuilt 2021 · S/N 172S12751 N331MEHarrison Matthew T · Naponee, NEBuilt 2000 · S/N 172S8464 N331RPRaritan Valley Flying School · Princeton, NJS/N 172S9863 N3327GWhitewater Aviation Inc · Harrison, OHBuilt 1972 · S/N 17261224 N3328ENorthwoods Air LLC · Orono, MES/N 17271505 N332CPCivil Air Patrol · Maxwell Afb, ALBuilt 2018 · S/N 172S12137 N332JCS&S Aircraft Inc · Bennington, VTS/N 17258514 N332MCClover Park Technical College · Lakewood, WABuilt 2026 · S/N 172S13551 N332SPMh Aviation LLC · Foster City, CABuilt 2020 · S/N 17281118 N3330EJarco Air LLC · Fitchburg, MABuilt 1978 · S/N 17271507 N3334EJarmer Ryan F Trustee · San Diego, CABuilt 1978 · S/N 17271509

Back to AD 90-06-03 R1