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.

N5869DDorsch Zachary William · Nampa, IDS/N 22-4548 N5870PPaul Eric C · Grapevine, TXBuilt 1959 · S/N 24-953 N5871PHammons John A · Maurice, LABuilt 1959 · S/N 24-954 N5871ZJohnson Nathan P · Rapid City, SDBuilt 1963 · S/N 22-9729 N5872ZCollins James T · Blossvale, NYBuilt 1963 · S/N 22-9728 N5873ZSchramm Thomas L · South Rockwood, MIBuilt 1963 · S/N 22-9731 N5874ZGodbey Patrick · St Simons Island, GABuilt 1963 · S/N 22-9732 N5875ZReed John F · Bemus Point, NYBuilt 1963 · S/N 22-9733 N5876DKirkendall James · N Richlnd Hls, TXBuilt 1956 · S/N 22-4557 N5876ZDraper Scott · Rutland, VTBuilt 1963 · S/N 22-9736 N587TPPockrus Pat B · Mineral Wells, TXBuilt 1958 · S/N 22-587 N5882PEvans Gene · Henderson, TXBuilt 1959 · S/N 24-967 N5883ZMckernan Thomas H · Gabriels, NYBuilt 1963 · S/N 22-9745 N5885PCostanzo Christopher P · Staten Island, NYBuilt 1959 · S/N 24-970 N5885ZLewis Vincent E · Oregon, MOBuilt 1963 · S/N 22-9747 N5886ZArgabright Jeremy E · Bloomfield, MTBuilt 1963 · S/N 22-9750 N5887YAlmost There Air LLC · Daytona Beach, FLBuilt 1965 · S/N 27-3040 N5888PRegistered aircraftS/N 24-973 N5888ZGoldberg David C · Garner, NCBuilt 1963 · S/N 22-9752 N588CPTjomsland Bryan · Culver City, CABuilt 1958 · S/N 24-431 N588NDChristiansen Aviation LLC · Wilmington, DEBuilt 2006 · S/N 4496233 N5890PDaniels David R · Anthony, NMBuilt 1959 · S/N 24-975 N5892ZCarbiener Ross · Kewanee, ILBuilt 1963 · S/N 22-9756 N5893ZKugmach LLC · Holdrege, NEBuilt 1963 · S/N 22-9758 N5894ZRussell Webster K · Ridgeland, MSS/N 22-9759 N5895ZMerrick Richard W · Bernville, PABuilt 1963 · S/N 22-9761 N5896PBurwell Brent C · New Ulm, TXBuilt 1959 · S/N 24-983 N5896YPatentcentral LLC · Hollywood, FLBuilt 1965 · S/N 27-3051 N589NDUniversity Of North Dakota John D Odegard School · Grand Forks, NDBuilt 2026 · S/N 4496635 N58KMOjito Osvaldo A · Miami, FLBuilt 1974 · S/N 27-7405440 N58PGTeterboro School Of Aeronautics Inc · Virginia Beach, VABuilt 1967 · S/N 27-3772 N58PJTaylor John W · Carrizo Springs, TXBuilt 1958 · S/N 24-225 N58RJLogan Flyers LLC · Logan, OHBuilt 1968 · S/N 27-3971 N58YTatko Philip J · Middle Granville, NYBuilt 1963 · S/N 22-9652 N5900ZLindsay Clyde M Jr · Rowland, NCBuilt 1963 · S/N 22-9765 N5901PDavis Kevin L · Alvin, ILBuilt 1959 · S/N 24-986 N5901ZGroom Ronald Ollie · Brownwood, TXBuilt 1963 · S/N 22-9766 N5902ZRegistration Pending · Kenai, AKRegistration pendingBuilt 1963 · S/N 22-9767 N5903PSpellman Henry A · Lincoln, ILBuilt 1959 · S/N 24-988 N5906PHereford America Inc · Reva, SDBuilt 1959 · S/N 24-992 N5907PSale Reported · St Francis, KSSale reportedBuilt 1959 · S/N 24-993 N5908DClark Stephen N · Walnut Cove, NCBuilt 1956 · S/N 22-4570 N5908PHollister Jet Center Inc · Hollister, CAS/N 24-994 N5909PMarsell Wendy T · Layton, UTBuilt 1959 · S/N 24-995 N590NDChristiansen Aviation LLC · Wilmington, DEBuilt 2009 · S/N 4496269 N5910DEastin Toby M · Jefferson City, MOBuilt 1956 · S/N 22-4572 N5910ZBishop David E · Butlerville, INBuilt 1963 · S/N 22-9777 N5911LSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2001 · S/N 4496102 N5911YDileo Steven J · Gallatin, TNBuilt 1965 · S/N 27-3067 N5911ZDavis Jim F · Poteau, OKBuilt 1963 · S/N 22-9778

Back to AD 85-02-05 R1