Skip to content

Registered aircraft · 72,010

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-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N5552GStracar Miro · Syosset, NYS/N 1278 N5552VJust Plane Stuff Inc · Jackson, MSBuilt 1980 · S/N 172RG0570 N55533Gw Aero LLC · Ponte Vedra Beach, FLBuilt 1973 · S/N 28R-7335249 N5553JHein Investments LLC · Omro, WIBuilt 1968 · S/N 32-1016 N5553PJones Warwick L · Torrance, CAS/N 1305 N5553QLieff Daniel · Yellow Springs, OHBuilt 1965 · S/N 2965 N5553UMcdonough Brian E · Harrisburg, PABuilt 1969 · S/N 28-26278 N55542Colorado Cherokee Flyers LLC · Boulder, COBuilt 1973 · S/N 28-7325429 N5554DValiair Limited Company Trustee · Casper, WYBuilt 1965 · S/N 28-2228 N5554EValiair Limited Company Trustee · Casper, WYBuilt 1977 · S/N 28-7725152 N5554JC M Lindsay And Sons Inc · Lumberton, NCBuilt 1968 · S/N 32-1017 N5554UNeeley Stephan B · Dighton, KSBuilt 1969 · S/N 28-26279 N5554WFlyworx LLC · Kalispell, MTBuilt 1962 · S/N 28-646 N55551Mahmud Fawzi S · Enid, OKBuilt 1973 · S/N 28-7325328 N55558Wagner Mark · Medina, WABuilt 1973 · S/N 28-7325368 N55559Mcconnachie Craig · Bullhead City, AZBuilt 1973 · S/N 28-7305392 N5555AGellner Sy D · Billings, MTS/N 28-860 N5555DReed Tony S · Mullica Hill, NJBuilt 1999 · S/N 18280459 N5555JSawyer James K · Odessa, FLBuilt 1968 · S/N 32-1019 N5555WLemieux Patrick · San Luis Obispo, CABuilt 1962 · S/N 28-647 N55563Sanchez Alejandro Arturo · El Paso, TXBuilt 1973 · S/N 28-7325433 N55564Moore Ryan J · Corvallis, ORBuilt 1973 · S/N 28-7305414 N55565Brickweg Kurt J · Cincinnati, OHBuilt 1973 · S/N 28-7305415 N55566Speck G Dan · Roaring Spring, PABuilt 1973 · S/N 28R-7335252 N5556PEasley Gary M · Comanche, TXBuilt 1958 · S/N 24-620 N5556UCynthiana Flying Group Corp · Cynthiana, KYBuilt 1969 · S/N 28-26282 N55578Gardiner Merrill L · Traverse City, MIBuilt 1973 · S/N 28-7325435 N5557JSmtm Holdings Inc · Wilmington, DEBuilt 1991 · S/N 1326 N5557PN5557p Delta Charlie Aviation Inc · Rockwall, TXBuilt 1958 · S/N 24-621 N55585Kankakee Area Flying Group LLC · Gilman, ILBuilt 1973 · S/N 28-7305418 N5558FConner Brad S · Waynesville, OHBuilt 1968 · S/N 28-24898 N5558WPatterson Troy V · Arlington, TXS/N 28-650 N55593Flying Life LLC · Fuquay Varina, NCBuilt 1973 · S/N 28-7305400 N55596Outdoor Products Of Louisiana LLC · Heflin, LAS/N 28-7325439 N55597Arndt Douglas E · Marion, WIBuilt 1973 · S/N 28-7305421 N55598Smith Gregory E · Manila, ARS/N 28-7305422 N55599Manning Holdings LLC · Portland, ORBuilt 1973 · S/N 28R-7335256 N5559FEsteban Granwel · Johnson City, TNBuilt 1968 · S/N 28-24899 N5559MBertelson Chester J · Modesto, CABuilt 1967 · S/N 096 N5559PSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1958 · S/N 24-623 N5559ZTrinidad 92 LLC · The Villages, FLBuilt 1992 · S/N 1279 N555AEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1962 · S/N 1001 N555AKBusy Bee Helicopter LLC · Paulding, OHBuilt 1993 · S/N 535 N555AMEdgewater Ventures LLC · Friday Harbor, WABuilt 1978 · S/N 32R-7885187 N555AWRamakrishna Murali DBA · Malden, MABuilt 2010 · S/N 536-2010 N555AXWalsh David · North Platte, NEBuilt 2001 · S/N 9927CC N555AZN555az LLC · Herndon, VABuilt 1969 · S/N 28-26585 N555BECrocker William D · Toledo, WABuilt 1973 · S/N 28R-7335254 N555BNEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 2001 · S/N 1079 N555BPBayusik Kevin R · Shelton, CTBuilt 1980 · S/N 32R-8029072

Back to AD 87-10-06 R1