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.

N631ACKcsi Aerial Patrol Inc · Bakersfield, CABuilt 2000 · S/N 450-2000 N631DMPlehn John C · Sandy Valley, NVBuilt 2004 · S/N 1355-2003 N631FLMiller William H · Blue Mound, ILBuilt 1971 · S/N 28-7125526 N631FTFlorida Institute Of Technology · Melbourne, FLBuilt 1981 · S/N 28-8216036 N631RVMichigan Tail Draggers LLC · Macomb, MIBuilt 2003 · S/N 24746 N6320FJohn D Strohsahl Pa Trustee · Fort Lauderdale, FLBuilt 1979 · S/N 17273190 N6320JJns Corp · Wilmington, DEBuilt 1968 · S/N 28-4728 N6320QLucas Warr & White LLC · Florence, SCBuilt 1967 · S/N 670139 N6320RGehr Garner J · Eustis, FLS/N 172RG0163 N6321JPrecision Aircraft Service LLC · Staples, MNBuilt 1968 · S/N 28-4729 N6322JBaus Mark L · La Crosse, KSBuilt 1968 · S/N 28-4730 N6322NThelander Edwin · Bristol, MEBuilt 1967 · S/N 157 N6323Spence Vincent Anthony · Arlington, TNBuilt 1974 · S/N 1002 N6323JYoung Troy D · Vernon, TXS/N 28-4731 N6323NRay Raymond Heath · Louisville, KYBuilt 1967 · S/N 158 N6323PJeffs Andrew S · Phoenix, AZBuilt 1959 · S/N 24-1433 N6323RSeigel Virginia L · Havre, MTBuilt 1966 · S/N 28-21490 N6323WMedicine By Design Inc · Miami, FLBuilt 1964 · S/N 28-20379 N6324PPorter John A · Cody, WYS/N 0094 N6325DCox Ronnie L · Whitesburg, GABuilt 1979 · S/N 17272717 N6325JBantle Flyers LLC · North Chesterfield, VABuilt 1968 · S/N 28-4733 N6325LStearns Edwin Ben Jr · Eloy, AZS/N 1386 N6325RVaught Janet M · Creedmoor, NCBuilt 1966 · S/N 28-21492 N6326EKevin Formica Inc · Boca Raton, FLS/N 17272006 N6326FAirtime Holdings LLC · Charleston, SCBuilt 1979 · S/N 17273191 N6326QMontpelier Gary L · Bushnell, FLBuilt 1967 · S/N 670125 N6326RBlancett-Maddock David D · Kailua Kona, HIBuilt 1966 · S/N 28-21494 N6326WKipkurui Stephen · Fort Worth, TXBuilt 1964 · S/N 28-20382 N63273Hlavinka Terrance J · East Bernard, TXBuilt 1981 · S/N 17275411 N63279P & H Air Inc · Overland Park, KSBuilt 1981 · S/N 17275412 N6327QHarrod Tracey Lynn · Bedford, KYBuilt 1967 · S/N 670126 N6328JWildflower Remedies LLC · Millersburg, OHS/N 28-4736 N6329JBeavers Danny G · San Antonio, TXBuilt 1968 · S/N 28-4737 N6329PKhan Adam Iqbal Ahmed · Sanger, TXBuilt 1959 · S/N 24-1438 N6329QRegistration Pending · Zavalla, TXRegistration pendingBuilt 1967 · S/N 670128 N6329RLomax Robert P · Belfair, WABuilt 1966 · S/N 28-21497 N6329WKingsley Kaland W · Miller, MOBuilt 1964 · S/N 28-20385 N632BGGoff Brad · Caldwell, IDBuilt 2023 · S/N NSK0707 N632DWHorinek David L · Goodland, KSS/N 310 N632KMouzakis Shaun Kevin II · Johnstown, COBuilt 2001 · S/N 433-2001 N632SFEccker Donald E · Ramona, CABuilt 1993 · S/N 740 N6330JBrashear Don F · Orcas, WABuilt 1968 · S/N 28-4738 N6330RLuton Christopher S · Cedar Park, TXBuilt 1966 · S/N 28-21498 N63312Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17275419 N6331CLambert James Donald · Sterling, COBuilt 1978 · S/N 28-7816408 N6331NMartens Air Service LLC · North Platte, NEBuilt 1967 · S/N 89 N6332DBlue River Aviation LLC · Wasilla, AKBuilt 1979 · S/N 17272720 N6332REllis Mark D · Parma, OHBuilt 1966 · S/N 28-21501 N6333FMattuski Joseph C Jr · Parker, COFirst renewal noticeBuilt 1979 · S/N 17273193 N6333PNoyes Tony · Lewisville, TXBuilt 1959 · S/N 24-1443

Back to AD 79-10-03 R2