Skip to content

Registered aircraft · 8,920

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N5541ZSpivey Harold E · Thomaston, GABuilt 1961 · S/N 22-8958 N5543ZKiendl Philip R · Carabaset Vly, MEBuilt 1962 · S/N 22-9334 N5544ZBetween The Seams Inc · Locust Grove, GABuilt 1962 · S/N 22-9335 N5545PVouk Frank E · Firth, IDBuilt 1958 · S/N 24-609 N5545YKolarek Frank · West Nyack, NYFirst renewal noticeBuilt 1964 · S/N 27-2644 N5545ZPiper Aviation Museum Foundation · Lock Haven, PABuilt 1962 · S/N 22-9337 N5546PMowinski Frank R Jr · Ray, MIBuilt 1958 · S/N 24-610 N5548ZJurgens Noel G · Mound City, KSFirst renewal noticeBuilt 1962 · S/N 22-9340 N5549ZRegistration Pending · Bloomsburg, PARegistration pendingBuilt 1962 · S/N 22-9341 N5550ZShippers Michael S · Williamson, NYBuilt 1962 · S/N 22-9342 N5551PLarsen Jordan · Draper, UTS/N 24-616 N5551ZKons Emily Ap · Bear Creek, WIBuilt 1962 · S/N 22-9343 N5552ZBurns William C · Vernon, MIS/N 229344 N5554ZWeddle Curtis E · Iowa Park, TXBuilt 1962 · S/N 22-9347 N5555ZKramer Brian J · Seattle, WABuilt 1962 · S/N 22-9348 N5556PEasley Gary M · Comanche, TXBuilt 1958 · S/N 24-620 N5557PN5557p Delta Charlie Aviation Inc · Rockwall, TXBuilt 1958 · S/N 24-621 N5559PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 24-623 N555DCAmoroso Ricardo C · Powder Springs, GABuilt 1959 · S/N 23-1780 N555HFChristiansen Aviation LLC · Wilmington, DEBuilt 2003 · S/N 4496176 N555NSN8241r LLC · Leawood, KSBuilt 1969 · S/N 30-1790 N555PRHarlan Thomas D · Fresno, CABuilt 1969 · S/N 27-4248 N5561ZHoward David D · Winner, SDBuilt 1962 · S/N 22-9358 N5563PVahey James T III · Loxahatchee, FLBuilt 1958 · S/N 24-627 N5563ZTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1962 · S/N 22-9360 N5566PTwig And Giggleberries LLC · Wichita Falls, TXBuilt 1958 · S/N 24-630 N5566ZAlex Lawrence P · Loves Park, ILBuilt 1962 · S/N 22-9363 N5567PRegistered aircraftS/N 24-631 N5568PSimon Jack · Spring Hill, TNBuilt 1958 · S/N 24-632 N5569PSpirit Wings Ltd · Wilmington, DEBuilt 1958 · S/N 24-633 N5569ZLevandowski Joseph · Hamburg, NYBuilt 1962 · S/N 22-9273 N556PCChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 4496074 N5570ZShippers Lee D · Wolcott, NYBuilt 1962 · S/N 22-9364 N55713Mid Continent Aircraft Corp · Hayti, MOBuilt 1973 · S/N 36-7360007 N5571PDaube Timothy B · Hampton, VAS/N 24-635 N5571VColeman Douglas E · Tallahassee, FLBuilt 1959 · S/N 23-1784 N5571ZGlass John · San Luis Obispo, CABuilt 1962 · S/N 22-9366 N5572ZGilmer Rickey W · Cropwell, ALBuilt 1962 · S/N 22-9369 N5573ZHerrick David · Mont Vernon, NHBuilt 1962 · S/N 22-9373 N55752Snyder Spraying Service Inc · Snyder, OKBuilt 1973 · S/N 36-7360009 N5575ZLareaux Jon R · Calumet, MIS/N 22-9375 N5576PMark Stephens Farm Inc · Dutton, MTBuilt 1958 · S/N 24-640 N5577PHall Edmond · Bremerton, WAS/N 24641 N5577ZBerdine Kenneth B · Arnoldsburg, WVBuilt 1962 · S/N 22-9378 N5579PBucciarelli Dominick F · Pueblo, COBuilt 1958 · S/N 24-643 N5579YHepner Glenn L · New Port Richey, FLBuilt 1964 · S/N 27-2684 N5580PJustice Nell E · Palmdale, CABuilt 1959 · S/N 24-644 N5580ZMorrow G Warren · Center, MOS/N 22-9382 N5582PPierce Stephen C · O Fallon, MOBuilt 1958 · S/N 24-646 N5582ZStottlemyer Bradley J · Lake Geneva, WIBuilt 1962 · S/N 22-9387

Back to AD 85-02-05 R1