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.

N4363DRaf Aircraft Pilot Services LLC · Wilmington, DEBuilt 1984 · S/N 28-8416098 N4363JWoeste Joseph R · Sauk Centre, MNBuilt 1967 · S/N 28-22870 N4363RSky Walker Flight School LLC · Adrian, MIBuilt 1974 · S/N 17263114 N4363ZOcean Aerial Ads Inc · Berlin, MDBuilt 1968 · S/N 18-8682 N43647Zg Aviation LLC · Alexandria, MNBuilt 1974 · S/N 28-7415549 N43648Bels Holdings LLC · Albert Lea, MNBuilt 1974 · S/N 28-7415550 N4364APapp Frank J · Fort Mohave, AZS/N 22-3716 N4364JDuffin Glenn R · Woodland Hills, UTBuilt 1967 · S/N 28-22743 N4364PMeehan Patrick K · Anchorage, AKBuilt 1960 · S/N 18-7444 N4364TComputec Technical Solutions Inc · Eighty Four, PABuilt 1984 · S/N 28-8416102 N4365Wells Canda R · Holdrege, NES/N PA-PA N43650Hughes Richard B · Annapolis, MDBuilt 1974 · S/N 28-7415551 N43652Tarcelo Maria Jocelyn F · Sun City, CABuilt 1984 · S/N 28-8416107 N43654Aeroventures Flying Club Inc · Lawrenceville, GABuilt 1984 · S/N 28-8490086 N43655N43655 LLC · Newark, DEBuilt 1984 · S/N 28-8490087 N4365DGriffin Donald A · Alma, ILBuilt 1984 · S/N 28-8416105 N4365FBumgardner Jerry C · La Crosse, WIBuilt 1984 · S/N 28-8490082 N4365JHofer Jeffrey · Lugoff, SCBuilt 1967 · S/N 28-22744 N4365QJackson Rickey L · Edmond, OKBuilt 1971 · S/N 17260265 N4365RCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1974 · S/N 17263116 N43661Gordon James R · Greenwood, INBuilt 1974 · S/N 28-7415554 N4366JRegistration Pending · Daytona Beach, FLRegistration pendingBuilt 1967 · S/N 28-22745 N4366RHyland Mark R · Poland, MEBuilt 1974 · S/N 17263117 N43671Rush Micah N · Salem, ORS/N 28-7415555 N4367GDimenno Phillip A · Windermere, FLBuilt 1984 · S/N 28-8490090 N43685Horizon Aviation LLC · Brooks, GABuilt 1974 · S/N 28-7415557 N4368HMuskogee Airmen Inc · Muskogee, OKFirst renewal noticeBuilt 1984 · S/N 28-8416110 N4368UBorges Jr Frank · Angwin, CABuilt 1984 · S/N 28-8490094 N4368VWaunch Robert L Trustee · Eastsound, WABuilt 1984 · S/N 28-8490095 N43693Milazzo Robert J · Sudbury, VTBuilt 1974 · S/N 28-7415559 N43695Kinney Ian · Calhoun, LABuilt 1974 · S/N 28-7415560 N4369AWinston William A · Bremo Bluff, VABuilt 1956 · S/N 22-3722 N4369NJ J Bagley Transportation Co LLC · Chalfont, PABuilt 1984 · S/N 28-8490096 N436ACKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 2000 · S/N 411-2000 N436NDFly By Knight Inc · Hammond, LABuilt 2004 · S/N 2842213 N436PABird Acquisition LLC · Phoenix, AZBuilt 2001 · S/N 4496079 N436PDDibartolo Michael · Wasilla, AKBuilt 1955 · S/N 18-4238 N436RMRocky Mountain College · Billings, MTBuilt 1979 · S/N 17273662 N436SKTds Property Holdings LLC · Gilmer, TXBuilt 1999 · S/N 2954 N43700Aviation Career Enrichment Inc · Atlanta, GABuilt 1984 · S/N 28-8416117 N43707Namah LLC · Gadsden, ALBuilt 1974 · S/N 28-7415561 N4370AMacdonald Kenneth A · Willow, AKBuilt 1956 · S/N 18-4772 N4370JDreyer Elwain C · Cardington, OHS/N 28-22754 N4370KHodges Berry Farm LLC · Willacoochee, GABuilt 1984 · S/N 28-8416116 N4370NThunderbird Aviation · Bloomington, MNBuilt 1984 · S/N 28-8490098 N4370RSkar Paul R · Londonderry, NHBuilt 1974 · S/N 17263121 N4370XMcguirk Michael S · Johnstown, PABuilt 1975 · S/N 28-7625014 N43711Airmart Inc · Lexington, KYBuilt 1974 · S/N 28-7415562 N43717A Comet Aviation LLC · Altus, OKBuilt 1974 · S/N 28-7415563 N4371AWest Transport LLC · Anchorage, AKBuilt 1956 · S/N 18-4773

Back to AD 79-10-03 R2