Registered aircraft · 40,395

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.

N211LEHardesty Jerry L · Terrebonne, ORBuilt 1983 · S/N 628 N211LTTraver Larry L · Sturgis, SDBuilt 2008 · S/N SD-51438-2008 N211MHWings Over Texas Holdings LLC · Denton, TXS/N 2082 N211MKWk Construction LLC · Meade, KSBuilt 2000 · S/N 23481 N211MMAir Images Co LLC · Cochranville, PAS/N 1951 N211NJCoco Aircraft Inc · Merritt Island, FLBuilt 1998 · S/N 2842043 N211NPSeto Peter A · Anderson Island, WABuilt 1995 · S/N 336 N211PTCappe Investment Group LLC · Homestead, FLBuilt 1972 · S/N 17261023 N211RATucker Robert B · Melba, IDBuilt 1999 · S/N 5292 N211SCBc & Cs Holding LLC · Waxahachie, TXBuilt 1969 · S/N 690042 N211SMDingler Larry G · Dryden, TXBuilt 1991 · S/N 2011 N211WFPyfl Kolby A · Maxwell, CABuilt 2015 · S/N 1075 N211XSmith Amy E · Raymond, NHS/N 8 N2121TSiebols Johan · Friendswood, TXS/N AA5B-1031 N2121UBurk Timothy R Trustee · Ramona, CABuilt 1989 · S/N BW002 N2121WSambell Warren D · Arlington, TXBuilt 1973 · S/N M1493 N21228Atp Aircraft 4 LLC · Wilmington, DEBuilt 1978 · S/N 44-7995043 N2122JCharles City Aeronautics Inc · Charles City, IABuilt 1978 · S/N 28-7916199 N2122LWare Pat · Farwell, TXFirst renewal noticeBuilt 1978 · S/N 28-7990257 N2122RAdventure North Flying Service LLC · Aitkin, MNS/N 28-5464 N2122WRegistration Pending · Ubly, MIRegistration pending, pending cancellationS/N M-1495 N21237Parker Jeff · Chelsea, ALBuilt 1974 · S/N 17263911 N2123AItechnology Design Inc · Gypsum, COBuilt 1978 · S/N 28-7990105 N2123WSimmons Aeronautical LLC · Springfield, MOBuilt 1973 · S/N M-1496 N21246Eastern Stearman Inc Trustee · Leesburg, VAS/N 17263914 N21249Western Kentucky Petroleum Inc · Osage Beach, MOS/N 17263916 N2124FHesseltine Robert J · Grand Terrace, CABuilt 1978 · S/N 28-7916173 N2124JDomas Jeffrey P · Mankato, MNBuilt 1978 · S/N 28-7916201 N2124NLivestock Service Inc · Douglas, AZBuilt 1951 · S/N 18-259 N2124WSerra Joseph I · Inverness, FLBuilt 1973 · S/N M-1497 N2125WWittmer Daniel J · Tucson, AZBuilt 1973 · S/N M-1499 N2126JChristie Ian A H · Limon, COS/N HB007 N2126WFormanek Carl F · Glen Flora, WIBuilt 1974 · S/N M-1502 N2126XCandace A Learned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 44-7995273 N21272Eagle Aviation Inc · Tucson, AZBuilt 1974 · S/N 17263920 N2127DMetro Aircraft Co · Bloomington, MNBuilt 1978 · S/N 447995131 N2127PDerbenwick Gary F · Colorado Springs, COBuilt 1979 · S/N 28-7990291 N2127RCohen Blanche F · Aurora, COBuilt 1969 · S/N 28-5465 N21281Horne Randall W · Millington, TNBuilt 1972 · S/N 18261535 N21288Cunningham Campers Inc DBA · Clarksville, INBuilt 1978 · S/N 28-7990040 N21289High Flight Academy LLC · Allison Park, PABuilt 1974 · S/N 17263923 N2128CStrite Logan Dean · Robbins, NCS/N 473 N2128EFly For Fun LLC · Rockville, MDBuilt 1978 · S/N 17271165 N2128WDelgado David A · Fallbrook, CABuilt 1973 · S/N M-1504 N2128XWnc Aviation LLC · Arden, NCBuilt 1979 · S/N 44-7995276 N21295Tauscher Robert C · Friday Harbor, WABuilt 1974 · S/N 17263925 N2129UMarzich Frank M · Rockford, ILBuilt 1962 · S/N 177 N2129WDuknic Derek · Magnolia, TXBuilt 1973 · S/N M-1500 N212AAGudger David T · Warwick, MDBuilt 1988 · S/N 212 N212AJDexter James R · Olathe, KSBuilt 1988 · S/N 575

Back to AD 79-10-03 R2