Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N554PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842091 N554RRegistered aircraftBuilt 1976 · S/N 28-7690382 N554RVSullivan Michael · Columbia, SCS/N 24710 N55502Blue Valley Flying Club Inc · Denton, NES/N 28-7305401 N55504University Cherokee Club LLC · Lincoln, NEBuilt 1973 · S/N 28-7305402 N55505Bothwell Brandon W · Mooresville, MOS/N 28-7305403 N55506Lugo Rullan Javier A · Adjuntas, PRBuilt 1973 · S/N 28-7325424 N5550JOptima Aviation LLC DBA · Lewisville, TXBuilt 1980 · S/N 17273818 N5550MHamblin Michael J · Seatac, WABuilt 1967 · S/N 088 N5550UFarm Air Service Inc · Pingree, NDBuilt 1969 · S/N 28-26274 N5550WStone Oren · Erick, OKS/N 28-641 N55513Spoon River Flyers Inc · Avon, ILBuilt 1973 · S/N 28-7305405 N55514Loomis Christopher · Cumming, GABuilt 1973 · S/N 28-7305406 N55515Fly Cessna LLC · Peoria, AZBuilt 1981 · S/N 17275195 N5551FFriest Eric J · Menomonie, WIBuilt 1968 · S/N 28-24890 N5551WMurdter Lawrence M · Sunnyvale, CABuilt 1962 · S/N 28-642 N55521Carter Flygare Inc · Sacramento, CABuilt 1981 · S/N 17275196 N55525Gustafson Michael Luther · Groveland, CABuilt 1973 · S/N 28-7325426 N55529Carrozzella Christopher · Wallingford, CTS/N 28-7305407 N5552EAbove And Beyond Aviation LLC · Austin, TXS/N 17271887 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 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 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 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 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 N5559FEsteban Granwel · Johnson City, TNBuilt 1968 · S/N 28-24899 N5559MBertelson Chester J · Modesto, CABuilt 1967 · S/N 096 N555AEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1962 · S/N 1001 N555AKBusy Bee Helicopter LLC · Paulding, OHBuilt 1993 · S/N 535 N555AXWalsh David · North Platte, NEBuilt 2001 · S/N 9927CC

Back to AD 79-10-03 R2