Skip to content

Registered aircraft · 54,015

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:87-20-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2') 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:87-20-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
  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:87-20-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-20-03-R2')
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.

N735DYRegistered aircraftBuilt 1977 · S/N 18265353 N735EACivil Air Patrol · Maxwell Afb, ALBuilt 1985 · S/N 18504442 N735EBSpohn Craig C · Shreveport, LABuilt 1977 · S/N 18265356 N735ECTrillia Roy Alan John Trustee · Berkeley, CABuilt 1977 · S/N 18265357 N735EDState Of North Carolina · Morehead City, NCBuilt 1985 · S/N 185-04443 N735EENewbold Business Advisory LLC · Manassas Park, VABuilt 1977 · S/N 18265359 N735EHLaw Offices Of Jorge Luis Flores LLC · Covington, GABuilt 1977 · S/N 18265362 N735EJTrashman Aviation LLC · Durant, OKBuilt 1977 · S/N 18265363 N735EKState Of North Carolina · Raleigh, NCBuilt 1985 · S/N 185-04444 N735ELBrown Aaron P · Joliet, ILBuilt 1977 · S/N 18265365 N735EMKing Jeffrey W · North Myrtle Beach, SCBuilt 1977 · S/N 18265366 N735EUErnst Albert S III · Buda, TXBuilt 1977 · S/N 18265373 N735EYSchneider J David · Montrose, COFirst renewal noticeBuilt 1977 · S/N 18265377 N735FViolette Charles H · Alto, NMBuilt 1959 · S/N 57005 N735FCIndian Bayou Aviation LLC · Indianola, MSBuilt 1977 · S/N 18265381 N735FDLee Ronald E · Tualatin, ORBuilt 1977 · S/N 18265382 N735FEZoeller Kenneth Harold · Billings, MTBuilt 1977 · S/N 18265383 N735FKUmeno Hiroo · Seattle, WABuilt 1977 · S/N 18265388 N735FNHughes James E Jr · Jasper, TXBuilt 1977 · S/N 18265390 N735FTBlakeslee David Shawn · Sierra Madre, CABuilt 1977 · S/N 18265395 N735FXD Plummer Enterprises Inc · Factoryville, PABuilt 1977 · S/N 18265399 N735FYHartman Raymond · Danville, ARBuilt 1977 · S/N 18265400 N735FZEchohealth Imaging LLC · Anacortes, WABuilt 1977 · S/N 18265401 N735GBCowboy Sky LLC · Enterprise, MSBuilt 1977 · S/N 18265403 N735GCOlgar Flying LLC · Ithaca, NYBuilt 1977 · S/N 18265404 N735GDHester Neal E · Visalia, CABuilt 1977 · S/N 18265405 N735GECianchette Family 3 LLC · Portland, MES/N 18504447 N735GKD L A Aircraft Inc · Wilmington, DEBuilt 1977 · S/N 18265411 N735GPBarnette Don A · Jonesboro, GAS/N 18265415 N735GQ735gq LLC · Corvallis, ORBuilt 1977 · S/N 18265416 N735GSPointcloud Aviation Inc · Plymouth, MNBuilt 1977 · S/N 18265418 N735GTTuomi Jane M · Anchorage, AKS/N 18265419 N735GUSenseney Ricky · Fishers, INBuilt 1977 · S/N 18265420 N735GVC B Air LLC · Franklin, TNS/N 18265421 N735GWCec Joseph D · Riverside, CAS/N 18265422 N735GXAga Aviation LLC · Mcallen, TXS/N 18265423 N735HBPierson Bradley A · Anchor Point, AKBuilt 1985 · S/N 18504448 N735HDFoster Jason Donald · Willis, TXBuilt 1977 · S/N 18265429 N735HFHatch David P · Tok, AKBuilt 1977 · S/N 18265431 N735HGSouthern Oaks Farm LLC · Lewes, DEBuilt 1977 · S/N 18265432 N735HHOptic Air LLC · St Maurice, IAS/N 18265433 N735HJLuckie Jessie O · Ashland, KSBuilt 1977 · S/N 18265434 N735HMFabco Enterprises LLC · Grand Rapids, MIBuilt 1977 · S/N 18265437 N735HRSkylane Inc · Idaho Falls, IDBuilt 1977 · S/N 18265441 N735HSDls Aviation LLC · Missoula, MTBuilt 1977 · S/N 18265442 N735HTKimmel Michelle D · Cushing, OKBuilt 1977 · S/N 18265443 N735HWLeask John A · Deerfield, OHBuilt 1977 · S/N 18265446 N735HXKenmore Crew Leasing Inc Trustee · Bellingham, WAS/N 18265447 N735JUS Aero Club LLC · Orlando, FLBuilt 1977 · S/N 18265812 N735JAMallery John · Olean, NYBuilt 1977 · S/N 18265450

Back to AD 87-20-03 R2