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.

N5582PPierce Stephen C · O Fallon, MOBuilt 1958 · S/N 24-646 N5582UPatterson Saralyn · Oklahoma City, OKS/N 28-26311 N5582WRieger Karen M · Indianapolis, INBuilt 1962 · S/N 28-697 N55838Hintenlang David · Archer, FLBuilt 1973 · S/N 28-7305435 N5583FAiken Pilot Training LLC · Johnston, SCBuilt 1968 · S/N 28-24916 N55840Walko Michael E · Scotch Plains, NJBuilt 1973 · S/N 28-7325551 N55842Ansboro James C · Goshen, NYBuilt 1973 · S/N 28-7325502 N55844Cozby Charles L · Wellsboro, PAS/N 28-7325503 N5584FGuiliano Anthony · Tobyhanna, PABuilt 1968 · S/N 28-24917 N5584QHurst Jonathan T · Seekonk, MABuilt 1964 · S/N 256 N5584WDill Mark B · Amarillo, TXBuilt 1962 · S/N 28-658 N55852Ingold Terry L · Albemarle, NCBuilt 1973 · S/N 28-7305484 N5585FSouth Texas Air Force LLC · Mission, TXBuilt 1968 · S/N 28-24918 N5585PBas Part Sales LLC · Greeley, COBuilt 1958 · S/N 24-649 N5585QCoxwell James · Midlothian, TXBuilt 1965 · S/N 2981 N5585WFoss Jason Steven · Cokato, MNBuilt 1962 · S/N 28-665 N5586USoisson Douglas M · Barnesville, GABuilt 1969 · S/N 28-26316 N55870Legacy Aviation LLC · Tea, SDS/N 28-7305487 N55871Van Wagner Aerial Media LLC · Hollywood, FLBuilt 1959 · S/N 18-6409 N55879Buchholtz Tony E · Greenville, OHBuilt 1973 · S/N 28-7325485 N55880Wings Up LLC · Saint Augustine, FLBuilt 1973 · S/N 28-7325517 N55881Phoenix Kingdom LLC · Washington, DCS/N 28-7325518 N5588FRckr Aviation LLC · Chehalis, WABuilt 1968 · S/N 28-24921 N5588UMontgomery Richard E · Omaha, NEBuilt 1969 · S/N 28-26318 N5588WBartz Nicole · Cleveland, MOBuilt 1962 · S/N 28-725 N55890S & L Sports LLC · New Hampton, IABuilt 1973 · S/N 28-7305492 N55899Aerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 28-7325521 N5589FTjl Aviation LLC · Atlanta, GABuilt 1968 · S/N 28-24922 N5589UGq Aviation LLC · Cherry Hill, NJBuilt 1969 · S/N 28-26320 N558AZHess Michael R · Alexandria, VAFirst renewal noticeBuilt 2004 · S/N 90399 N558FLRoyal Greene Holdings LLC · Spout Spring, VABuilt 1971 · S/N 28-7125399 N558JRichley Robert C · Lees Summit, MOBuilt 1985 · S/N 706 N558RBNash Garrett J · Bliss, IDBuilt 1997 · S/N 22833 N558SHAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 2004 · S/N 3582 N558SMTsvang Volodymyr · Redondo Beach, CABuilt 1975 · S/N 28-7505130 N558TLLally Timothy A · Bell Gardens, CABuilt 1989 · S/N 1838L N55905Top Coat Takeoff LLC · Cincinnati, OHBuilt 1973 · S/N 28-7305496 N5590FLee A Archer Jr Red Tail Youth Flying Progrom Inc · New Windsor, NYS/N 28-24923 N55913Buckner Business Services Inc · Trenton, MOBuilt 1973 · S/N 28-7305497 N55915Loncella James G · Johnstown, PABuilt 1973 · S/N 28-7305500 N5591WMontag Mark W · Pine River, WIBuilt 1962 · S/N 28-794 N55920Gillbreath Monty Everett · Livingston, TXS/N 28-7325529 N55925Goodwin Collin H · Hobbs, NMS/N 28-7325532 N5592FEagle Air Flying Club Inc · Bowling Green, OHBuilt 1968 · S/N 28-24879 N5592QGrant Charles A Jr · Denton, TXBuilt 1965 · S/N 2986 N5592VBlack Dog Air LLC · Satellite Beach, FLBuilt 1977 · S/N 28-7790482 N55930Lafrance Troy R · Paola, KSBuilt 1973 · S/N 28-7325534 N55933Knoxville Aviation · Knoxville, IAS/N 28-7305504 N55934Roloff Paul E Trustee · Waupaca, WIBuilt 1973 · S/N 28-7305505 N55938Turner Cole M · Round Rock, TXBuilt 1973 · S/N 287325536

Back to AD 79-10-03 R2