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.

N341SPSo Cal Leasing LLC · El Cajon, CABuilt 2003 · S/N 172S9497 N3421EWisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 17271539 N34264Aikens George A · Greeley, COBuilt 1959 · S/N 625 N3426ACarter Aaron T · Kasilof, AKBuilt 1961 · S/N 17248953 N3426DGaither Timothy · Inman, KSBuilt 1974 · S/N 17264275 N3426EJts Management Inc · Lincoln, NEBuilt 1978 · S/N 17271543 N34270Goza Samuel · Fresno, CABuilt 1960 · S/N 172630 N3429EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271545 N342SASunrise Aviation Inc · Ormond Beach, FLS/N 172S10475 N3435EBober Aviation Mountain Flying LLC · Hayesville, NCBuilt 1978 · S/N 17271547 N343CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12344 N343PTDiamond Head Aviation LLC · Kunia, HIBuilt 2005 · S/N 172S9831 N343SASunrise Aviation Inc · Ormond Beach, FLBuilt 2007 · S/N 172S10477 N343SPEight16 LLC · Lewes, DEBuilt 2003 · S/N 172S9498 N3442EOwens John W Sr · Myrtle Beach, SCBuilt 1978 · S/N 17271548 N3445EHicks Robert C · Atkins, VABuilt 1978 · S/N 17271551 N344CPBlain Robert · West Richland, WABuilt 1956 · S/N 28713 N344JEAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13472 N344RBContinental Aerospace Technologies Inc · Mobile, ALBuilt 2011 · S/N 172S11133 N344SPSun City Aviation LLC · Davie, FLBuilt 1999 · S/N 172S8267 N3455ESilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1978 · S/N 17271553 N3457ETri Star Aviation & Development Ltd · Bath, NCBuilt 1978 · S/N 17271554 N345AROhio University · Albany, OHBuilt 1980 · S/N 17274364 N345BPeraton Services LLC · Venice, CABuilt 1999 · S/N 172S8177 N345CHAce Flight Center Inc · St Thomas, VIBuilt 1980 · S/N 172RG0726 N345CSFlight Training Aircraft LLC · Wilmington, DEBuilt 2015 · S/N 172S11527 N345DESale Reported · Dover, DESale reportedBuilt 1972 · S/N 17260806 N345FBMarino Gregory G · Big Horn, WYBuilt 1967 · S/N 67-15214 N345FHHeavy Metal Air LLC · Farmingdale, NYBuilt 2012 · S/N 172S11160 N345KRBlue Sky Aviation Cayman Inc · Wilmington, DEBuilt 1974 · S/N 17264632 N345MEOtt James E · Redlands, CABuilt 2000 · S/N 172S8577 N345QASale Reported · Leesburg, FLSale reported, pending cancellationBuilt 1965 · S/N 17253628 N345WAWiseman Aviation Inc · Flagstaff, AZBuilt 1976 · S/N 17267522 N3461WBplj LLC · Old Monroe, MOBuilt 1972 · S/N 17261257 N3462ENc86 Flying Club Inc · Mooresville, NCBuilt 1978 · S/N 17271555 N346BSGulf Coast Aviation LLC · New Orleans, LABuilt 2004 · S/N 172S9757 N346CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13257 N346CPPinnacle Aviation Services Inc · Encinitas, CABuilt 1998 · S/N 17280346 N346KMitchell Flying Club Inc · Lees Summit, MOBuilt 1997 · S/N 17280064 N346SPFlightline Air Service LLC · Pineville, LABuilt 1999 · S/N 172S8268 N3475EOlmedo Refugio Junior · Lancaster, CABuilt 1978 · S/N 17271561 N3477EMorey Airplane Co Inc · Middleton, WIBuilt 1978 · S/N 17271563 N347CHAce Flight Center · St Thomas, VIBuilt 1974 · S/N 17263661 N347MENiemeyer Leasing LLC · Cave Creek, AZBuilt 2000 · S/N 172S8581 N347WGMt Aircraft LLC · Port Orange, FLBuilt 1968 · S/N 17256883 N348CHAce Flight Center Inc · St Thomas, VIS/N 17266564 N348CPHaddock Tracey P · Kingstree, SCBuilt 1998 · S/N 17280348 N348MEBlackstone Aviation LLC · Irvine, CAFirst renewal noticeBuilt 2000 · S/N 172S8582 N348SPSilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1999 · S/N 172S8273 N349ADEdelman Loren H · Sabetha, KSBuilt 1964 · S/N 17251516

Back to AD 90-06-03 R1