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.

N3337EAltitude Aviation LLC · Lenoir, NCBuilt 1978 · S/N 17271510 N3338VAero-Tech Services Inc · Lititz, PABuilt 2025 · S/N 172S13307 N333AFChickasha Wings Inc · Chickasha, OKBuilt 1972 · S/N 17260403 N333BTVaughan Garland Lynn · Canyon, TXBuilt 1975 · S/N 17265369 N333CEFera Margaret L · Allentown, PABuilt 1975 · S/N 17265260 N333JEJs Aviation Inc · Valparaiso, INBuilt 2026 · S/N 172S13562 N333KNKris Noone Air LLC · Wilmington, DEBuilt 1973 · S/N 17261426 N333KVScearce Richard D · Mount Vernon, IABuilt 1959 · S/N 46990 N333LSBrown Richard G · Blanchard, OKBuilt 1978 · S/N 17271006 N333RXJourneys Aviation Inc · Boulder, COBuilt 1966 · S/N 17254308 N333TSAerostar Management Services LLC · Kissimmee, FLBuilt 1999 · S/N 172S8240 N3346EEarnst Kelly S · West Lafayette, INBuilt 1978 · S/N 17271512 N3349SJin Jin Aviation LLC · Anchorage, AKBuilt 1984 · S/N 17276255 N334SPSierra Pop Air LLC · Wilmington, DEBuilt 2003 · S/N 172S9494 N3355EMiddletown Regional Flight Training Institute LLC · Middletown, OHBuilt 1978 · S/N 17271515 N335JCAlexander Melodie A · Lees Summit, MOBuilt 1956 · S/N 28785 N335MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12879 N335MECentral Iowa Aviation LLC · Ankeny, IABuilt 2000 · S/N 172S8466 N335RSYould Eric P Trustee · Palmer, AKBuilt 1977 · S/N 17268562 N335SPMaui Aviators LLC · Pukalani, HIBuilt 2003 · S/N 172S9495 N3363EMcfly LLC · Casper, WYBuilt 1978 · S/N 17271518 N3364EPlsr LLC · Denton, TXBuilt 1978 · S/N 17271519 N3369ERustmann Richard E · Willimantic, CTBuilt 1978 · S/N 17271520 N336AFLaine Carey E · Nevada City, CABuilt 1972 · S/N 17260404 N336DDNewman Christopher J · Lorena, TXBuilt 1960 · S/N 47254 N336MCLewis University · Romeoville, ILBuilt 2022 · S/N 172S12880 N336RSAirspeed Marketing LLC · Phoenix, AZS/N 17252228 N3371EWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271521 N3373BManley Steven T · Dallas, TXBuilt 1965 · S/N 17253577 N3378EVisalia Flyers LLC · Visalia, CABuilt 1978 · S/N 17271524 N337CACendejas Christian · Montclair, CABuilt 1979 · S/N 17272213 N337GFLewis John P · Alachua, FLBuilt 1969 · S/N 17258349 N337MEFlytcentrix LLC · Lewes, DES/N 172S8468 N3386ED Gordon Aviation Inc · La Jolla, CABuilt 1978 · S/N 17271526 N3389EBarnfather James D · Sequim, WABuilt 1978 · S/N 17271528 N338CALincoln Skyways Inc · Lincoln, CABuilt 1978 · S/N 17269465 N338GSSanders Flight Training Center Inc · Jasper, ALBuilt 2025 · S/N 172S13326 N3391EOcala Aviation Services Inc · Ocala, FLBuilt 1978 · S/N 17271529 N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119 N339SPCahill Michael · Moon Township, PABuilt 2003 · S/N 172S9496 N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784 N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989 N33FMAtp Aircraft 7 LLC · Wilmington, DEBuilt 2012 · S/N 172S11196 N33KYBurnette Ric A · Sebastian, FLS/N 17253910 N33LAOscar Tango LLC · Mesa, AZBuilt 2020 · S/N 172S12446 N33YPFlight Control Services Of Florida Inc · Milton, FLS/N 17272269 N340MTAcron Aviation Academy Inc · Sanford, FLBuilt 2006 · S/N 172S10374 N341CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13499 N341FAJb Aircraft LLC · Anchorage, AKS/N 17269321 N341FCCondor Aero Club Inc · Zelienople, PABuilt 1978 · S/N 17270371

Back to AD 90-06-03 R1