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.

N8899BBradberry Mason P · Wichita Falls, TXS/N 36599 N8899UYoon Kerry D · Franklin, TNBuilt 1965 · S/N 17252820 N889SDMedary Aviation LLC · Brookings, SDBuilt 2025 · S/N 172S13322 N889SPLeading Edge Aviation Inc · Spencer, IABuilt 2002 · S/N 172S9088 N88ABBrown James L · Athens, ALBuilt 1973 · S/N 17262739 N88EStarlite Aviation Technologies LLC · Las Vegas, NVBuilt 1973 · S/N 17261476 N88JAGc Aviation Services-1 LLC · Miamisburg, OHBuilt 2001 · S/N 172S8776 N88KWDonnell James C · Crowville, LABuilt 1966 · S/N 17254367 N88SYYamashita Bruce · Honolulu, HIBuilt 1969 · S/N 17258613 N89005Singh Fiyaad · Ocoee, FLBuilt 1997 · S/N 17280084 N8900BMathews Denis W · Quanah, TXBuilt 1958 · S/N 36700 N8901BThompson Douglas P Trustee · Alton Bay, NHBuilt 1958 · S/N 36701 N8902BLeonard William L · Gettysburg, PABuilt 1958 · S/N 36702 N8902VFlycarolina LLC · Concord, NCS/N 17264259 N8904VWaymaker Aviation LLC · Yukon, OKBuilt 1974 · S/N 17264261 N8905BGamble Dennis H · Cottonwood, ALBuilt 1958 · S/N 36705 N8906VLewis David A · Broadalbin, NYBuilt 1974 · S/N 17264263 N8907BRaven Aviation LLC · Lexington, KYBuilt 1958 · S/N 36707 N8908BAxmacher Mark A · Hillsboro, OHBuilt 1958 · S/N 36708 N890CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12635 N890EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2026 · S/N 172S13532 N890KCMustang Sally Aviation LLC · Camden, SCBuilt 2000 · S/N 17280890 N890PGCp Air LLC · Indianapolis, INBuilt 1965 · S/N 17253864 N8910BStone Tim · Siloam Springs, ARBuilt 1958 · S/N 36710 N8911BPeterson Clifford H · Old Town, MEBuilt 1958 · S/N 36711 N8911VHorizon Dreams LLC · Homer, GABuilt 1974 · S/N 17264268 N8912VRoper Jeff A · Corralitos, CABuilt 1974 · S/N 17264269 N8913VI'Ll Fly Away LLC · Florence, SCBuilt 1974 · S/N 17264270 N8916BSanborn George A Sr · Culver, ORBuilt 1958 · S/N 36716 N8916VTaylor William W Jr · Hudson Oaks, TXBuilt 1974 · S/N 17264273 N8917BTederman Terri Lynn · Auburn, WABuilt 1958 · S/N 36717 N8919VChristiansen John · Vicksburg, MIBuilt 1974 · S/N 17264276 N891SROmalley Benjamin P · River Falls, WIBuilt 1966 · S/N 17253588 N8921VN2827n LLC · Pembroke Pines, FLS/N 17264278 N8922VTampa Bay Aviation Inc · Clearwater, FLBuilt 1974 · S/N 17264279 N8924VDupree Johnny · Crossett, ARBuilt 1974 · S/N 17264281 N8926BEmery Marilyn L · Randle, WABuilt 1958 · S/N 36626 N8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1974 · S/N 17264283 N8927BSale Reported · Crystal, MNSale reportedS/N 36627 N8927VTropical Aviation LLC · Gulf Shores, ALBuilt 1974 · S/N 17264284 N8929BB&L Air Inc · Princeton, TXBuilt 1958 · S/N 36629 N892CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13059 N892EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12685 N8930BJohnson Kenneth J · Red Bluff, CABuilt 1958 · S/N 36630 N8931VAeroventures 8 LLC · Mt Carmel, TNS/N 17264288 N8932VEverett William M · Tuscumbia, ALBuilt 1974 · S/N 17264289 N89337Davis Andrea E · Lake Oswego, ORBuilt 1983 · S/N 17276002 N8934BPennington Clifford H · Mount Washington, KYBuilt 1958 · S/N 36634 N8934VUniversal Aviators Academy Inc · El Monte, CABuilt 1974 · S/N 17264291 N8936BPitman Marvin L · Harrah, OKS/N 36636

Back to AD 90-06-03 R1