Registered aircraft · 40,394

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.

N9592LHausknecht Brian · Corpus Christi, TXBuilt 1974 · S/N AA5-0592 N9592UN9592u LLC · Versailles, KYBuilt 1976 · S/N AA5A-0092 N9592WDreamcatcher Aviation LLC · Austin, TXS/N 28-23040 N9593BBehnke Christopher H · SiegburgBuilt 1981 · S/N 172RG0906 N9593HSaliba Bahig Nadim · Scottsdale, AZBuilt 1975 · S/N 17266252 N9593JPhillips Raymond A Jr · Vestal, NYBuilt 1966 · S/N 28-3732 N9593KShoham Aviation LLC · Richmond, TXBuilt 1976 · S/N 28-7625185 N9593LPeters Larry L · Sheffield, IABuilt 1974 · S/N AA5-0593 N9593VWeaver Robert D · Petersburg, WVBuilt 1974 · S/N 17264395 N9594HEagle Sky Patrol Inc · Deadwood, SDS/N 17266253 N9594JJensen Enterprises LLC · Iola, KSBuilt 1966 · S/N 28-3740 N9594SRuiz Santiago · Jupiter, FLBuilt 1965 · S/N 41 N9594UWilliams Jason R · Drums, PABuilt 1976 · S/N AA5A-0094 N9594WMiddlecoast Air LLC · Grand Rapids, MIBuilt 1967 · S/N 28-23044 N9595DSchlosser Joseph V · Rockford, MNBuilt 1958 · S/N 22-6502 N9595JMuller Chester E · Hayward, CABuilt 1966 · S/N 28-3741 N9595TWorden James L · Tucson, AZBuilt 1989 · S/N 1072 N9595UGrumman Squadron LLC · Prattville, ALBuilt 1976 · S/N AA5A-0095 N95962Forst Richard A · Sitka, AKBuilt 1989 · S/N 1093 N95965Colvin Kurt W · San Luis Obispo, CABuilt 1989 · S/N 1094 N9596DRoss Jack H · Portland, ORBuilt 1958 · S/N 22-6504 N9596HCorby Brenda K · Oak View, CABuilt 1976 · S/N 17266255 N9596JAstraeos Aviation LLC · Salisbury, NCBuilt 1966 · S/N 28-3742 N9596LPriebe John F · Troy, OHBuilt 1974 · S/N AA5-0596 N9596UOlds Jack R DBA · Madison, INBuilt 1976 · S/N AA5A-0096 N9596WFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N 28-23046 N9597BCanada Gary Jr · Coy, ARS/N 1095 N9597JWingswat LLC · Placentia, CABuilt 1966 · S/N 28-3743 N9597LRowe Richard D · Waterloo, INBuilt 1974 · S/N AA5-0597 N9597VSkelton Jeffrey · Sioux Falls, SDBuilt 1974 · S/N 17264399 N9598BIpsen Michael · Kenosha, WIBuilt 1981 · S/N 172RG0909 N9598DDurden William L · Tallahassee, FLBuilt 1958 · S/N 22-6506 N9598JMardis Andrew · Pelzer, SCBuilt 1966 · S/N 28-3744 N9598UJackler Leon J · Silver Spring, MDBuilt 1976 · S/N AA5A-0098 N9598ZDel Valle Enterprises Inc · Sandpoint, IDBuilt 1989 · S/N 1102 N9599JOrban Kenneth D · Tellico Plains, TNBuilt 1966 · S/N 28-3745 N9599KRed Wing Soaring Association · Osceola, WIBuilt 1989 · S/N 1111 N9599WNelson Scott G · Lakota, NDS/N 28-23050 N9599ZBorn John G · Jupiter, FLBuilt 1989 · S/N 1117 N959AGGrant Altin C · Tahlequah, OKBuilt 1973 · S/N 17701952 N959DBSigma Pharmaceuticals LLC · Monticello, IABuilt 1999 · S/N 14095C N959ERs Specialties LLC · Anchorage, AKBuilt 1955 · S/N 18-4021 N959HCNorthwest Wings LLC · Hillsboro, ORBuilt 1973 · S/N 17262361 N959PDMilligan Thomas A · Dana, INBuilt 2002 · S/N 1336-2002 N959RDDoering Ray A · Devils Tower, WYBuilt 1979 · S/N 18-7909159 N959RMLargent Richard B · Southport, NCBuilt 1970 · S/N 17259113 N959TELawless John M Jr · Tucson, AZBuilt 2004 · S/N 10238 N95AACoolidge Marvin L · Newberg, ORBuilt 1959 · S/N TD-256 N95AHBrown Hunter · Sulphur Rock, ARBuilt 1978 · S/N 18-7809152 N95BRChickasha Wings Inc · Chickasha, OKBuilt 1969 · S/N 28-25841

Back to AD 79-10-03 R2