Registered aircraft · 108,428

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:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') 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:2007-04-19-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
  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:2007-04-19-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
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.

N12275Bachman Mildred R · New Brighton, PABuilt 1965 · S/N G-263 N1227FPeterson Investments Inc · Polson, MTBuilt 1975 · S/N 18502789 N1227TStieper David Paul · Forest Lake, MNBuilt 1972 · S/N 28R-7235241 N1227UKelly William W · Springfield, ORBuilt 1976 · S/N 17266923 N1227XVan Hoosen Ronald L · Goldsby, OKBuilt 1963 · S/N 198 N1228Hodges Farms LLC · Grain Valley, MOBuilt 1987 · S/N 4608092 N12281Flippen John P · Bonita, CABuilt 1955 · S/N G-293 N1228ERag Experimental LLC · Klamath Falls, ORBuilt 1998 · S/N LIV190 N1228GMcdaniel Dean K · Mesa, AZBuilt 1974 · S/N 310Q1081 N1228MHillsboro Flying Club · Hillsboro, ORBuilt 1975 · S/N 18264247 N1228PPapa Aviation LLC · Chicago, ILBuilt 1990 · S/N E-2577 N1228REcko Air LLC · Springfield, MOBuilt 1989 · S/N 2841266 N1228UBig Sky Aviation LLC · Glenmora, LABuilt 1976 · S/N 17266924 N1228ZPate Ronald E · Hilltop Lakes, TXBuilt 1961 · S/N D-6688 N1229Fritzinger Thomas A · Maidens, VAS/N 1112 N12290Read Andrea · Austin, TXFirst renewal noticeBuilt 1973 · S/N 17261912 N12291Cisek Jason M · Westfield, MABuilt 1973 · S/N 17261913 N1229TPiper Electric Inc · Deer Park, NYBuilt 1972 · S/N 34-7250267 N1229UMcdonald Air Services LLC · Saint Johns, MIBuilt 1976 · S/N 17266925 N1229WScott George H · Springdale, ARBuilt 2000 · S/N 5258 N122AACnt Aviation LLC · Lake Tapps, WABuilt 2006 · S/N 11228 N122ADRegistered aircraftBuilt 2005 · S/N 81308 N122AJPalo Alto Aviators Inc · Menlo Park, CABuilt 2005 · S/N 1547 N122AKBarker Paul II · Rainbow City, ALBuilt 1991 · S/N 2028 N122AMHarper David · New Richmond, WIBuilt 1973 · S/N 310Q0943 N122BCChristiansen Aviation LLC · Wilmington, DEBuilt 2020 · S/N 172S12540 N122BPDiggins Charles J · Middleboro, MABuilt 1997 · S/N 22912 N122BRHollon Blake D · Douglas, WYBuilt 1958 · S/N TD-65 N122CERay Kevin T · Columbus, TXBuilt 1979 · S/N E-1475 N122CGHollywood Aviation Investments LLC · Hollywood, SCBuilt 2001 · S/N 0098 N122CPFlorida Seaplanes LLC · Altamonte Springs, FLBuilt 2001 · S/N 18064C N122CTTurner Eye Clinic Inc · Cabot, ARBuilt 1976 · S/N TE-1070 N122CVDonnellan William B · Chattanooga, TNBuilt 2003 · S/N 0450 N122DDBeacon Hill Leasing LLC · Plymouth, MIBuilt 1977 · S/N 27-7754120 N122DTFine Point Aviation LLC · Carrollton, GABuilt 2000 · S/N 18280908 N122EOne Two Two Echo Aviation LLC · Cincinnati, OHBuilt 1973 · S/N 310Q0984 N122EAHumpal Nathan A · San Antonio, TXBuilt 2003 · S/N 60553 N122EEAir-Burt LLC · Rochester Hills, MIBuilt 2013 · S/N TH-2382 N122EZLawley Frederick Ellsworth III · Castro Valley, CAS/N 1297 N122FSiver Creek Capital LLC · Emery, SDS/N 21058967 N122GHThompson Jason · River Heights, UTBuilt 2002 · S/N 0175 N122GPEide Michael C · Severn, MDBuilt 2006 · S/N DM0206 N122HSafeline Aviation LLC · Apache Junction, AZBuilt 1999 · S/N 1274-99 N122HSMarbury Sherri E · Jackson, TNBuilt 1965 · S/N 28-2377 N122JAChase James P · Waco, TXBuilt 2025 · S/N 18283320 N122JDGrasshopper Aviation LLC · Hockley, TXBuilt 2000 · S/N 1301-2000 N122JSGraham Design Services Inc · Dawsonville, GABuilt 1979 · S/N 18266866 N122KCRomero Garcia Moises · Park City, UTBuilt 2003 · S/N 2105-L N122KMBruce Mellor Inc · Escalon, CABuilt 2001 · S/N 0036 N122KPPeterson Keith D · Nevada City, CABuilt 2002 · S/N PETERSON-2

Back to AD 2007-04-19 R1