Skip to content

Registered aircraft · 20,687

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.

N8615UEmpire Air Of North Florida LLC · Waldo, FLBuilt 1965 · S/N 17252516 N8616BStewart Joel · Albany, NYBuilt 1957 · S/N 36316 N8616UKeltner Peter David · Traverse City, MIBuilt 1965 · S/N 17252517 N8617UDrozen Dale W · Clovis, CABuilt 1965 · S/N 17252518 N8618BRegistration Pending · Nacogdoches, TXRegistration pendingBuilt 1957 · S/N 36318 N8618UMorgan Ted R · Grant, FLBuilt 1965 · S/N 17252519 N8619BBasham James L · Livingston, TXBuilt 1957 · S/N 36319 N861AATextron Aviation Inc · Wichita, KSS/N 172S13624 N861ATChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 172S12411 N861AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12469 N861EREmbry-Riddle Aeronautical Univserity Inc · Daytona Beach, FLBuilt 2024 · S/N 172S13233 N8621BMcmillan Thomas J · Milburn, NEBuilt 1957 · S/N 36321 N8623UBarry Gehret · Sonoma, CAS/N 17252524 N8624USikora Randall P · Boca Raton, FLBuilt 1965 · S/N 17252525 N8625URubison John R · Shelbina, MOBuilt 1965 · S/N 17252526 N8626UFriedman Arthur M · Santa Paula, CABuilt 1965 · S/N 17252527 N8628BScarcella Joseph A · Redlands, CAS/N 36328 N8628UTownsend Slade · Fredonia, TXBuilt 1965 · S/N 17252529 N8629UHedberg Paul D · Atwater, MNBuilt 1965 · S/N 17252530 N862AUAuburn University · Auburn Univerity, ALBuilt 2020 · S/N 172S12470 N862CPN862cp LLC · Stuart, FLBuilt 1998 · S/N 17280566 N862TWTailwinds LLC · Ewing, NJBuilt 1978 · S/N 17271025 N8630UOcala Aviation Services Inc · Ocala, FLBuilt 1965 · S/N 17252531 N8633BPrigmore Phillip M · Alva, OKBuilt 1957 · S/N 36333 N8635BShafik Mohammed · Las Vegas, NVS/N 36335 N8636BFisher'S Crop Care By Air LLC · Fredericktown, OHS/N 36336 N8636UMls Holdings · Newbury Park, CABuilt 1965 · S/N 17252538 N8638ULittle Kenneth C · Driggs, IDBuilt 1965 · S/N 17252540 N863AUBas Part Sales LLC · Greeley, COBuilt 2020 · S/N 172S12471 N863PAUniversity Of Alaska Anchorage · Anchorage, AKBuilt 2002 · S/N 172S9062 N863SPLegacy Aviation LLC · Tea, SDBuilt 1999 · S/N 172S8122 N8640USunnyside Aviation Pllc · Theodosia, MOBuilt 1965 · S/N 17252542 N8641UJohnson Jay A · Lisbon, IABuilt 1965 · S/N 17252543 N8642BCommercial National Flooring Inc · New Carlisle, OHBuilt 1957 · S/N 36342 N8642DAmerican Aviation Inc · Tracy, CABuilt 1979 · S/N 172RG0061 N8644BUavionix Corp · Bigfork, MTBuilt 1957 · S/N 36344 N8644UFung Tak C · Ridge, NYBuilt 1965 · S/N 17252546 N864AUAuburn University · Auburn University, ALBuilt 2020 · S/N 172S12472 N864CKTabatabai Seyed Ali · Houston, TXBuilt 2005 · S/N 172S9864 N864PAMorris David · Fort Mill, SCBuilt 1982 · S/N 172RG1063 N864SPAmeriflyers Of Texas Inc · Addison, TXFirst renewal noticeBuilt 1999 · S/N 172S8123 N864TWTailwinds Academy Of Aviation · Philadelphia, PABuilt 1972 · S/N 17261013 N8650BKing Kenneth M · Charleston, SCBuilt 1957 · S/N 36350 N8653UCurtis Heather · Fairbanks, AKBuilt 1965 · S/N 17252555 N8654UThompson George C · Rogersville, ALBuilt 1965 · S/N 17252556 N8655BFredrickson Sherman E Jr · Norman, OKBuilt 1957 · S/N 36355 N8657URidley Timothy A · Uniontown, PABuilt 1965 · S/N 17252559 N865CKAero American Flight LLC · Houston, TXBuilt 2014 · S/N 172S11466 N865CPAmr Holdings LLC · Kalispell, MTBuilt 1998 · S/N 17280602 N865DAb Prop Plane II LLC · Metairie, LABuilt 2020 · S/N 172S12569

Back to AD 90-06-03 R1