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.

N155FRSpeed Aviation Holdings LLC · Lewes, DEBuilt 1970 · S/N TE-817 N155HBering Air Inc · Nome, AKBuilt 2011 · S/N 13134 N155JAStavrides Paul · Hartsville, PABuilt 1976 · S/N TC-1993 N155JB2mec Holdings LLC · Kalispell, MTBuilt 1966 · S/N TC-1025 N155JGDesch Edward J III · Aldie, VABuilt 2002 · S/N 80913 N155JHCrew Support LLC · Draper, UTBuilt 2014 · S/N 562-2014 N155JKDa Fuq Dat Beepin Be LLC · Saint Petersburg, FLBuilt 1977 · S/N 853 N155JWTcpb LLC · Lewes, DEBuilt 1975 · S/N D-9837 N155KKSmith Clifford Bryan · Newnan, GABuilt 1973 · S/N TC-1606 N155KPGlen Stone Contruction Inc · Henderson, KYFirst renewal noticeS/N 18263197 N155KTN155kt LLC · Dover, DEBuilt 1963 · S/N 21058196 N155LUnderwood Robert · Waxahachie, TXBuilt 1968 · S/N TE-467 N155LCAle & Quail Club LLC · Cheyenne, WYBuilt 1968 · S/N TE-615 N155LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842197 N155MBEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1990 · S/N 1550 N155MGVeracity Aviation LLC · Seguin, TXBuilt 2009 · S/N 12713 N155MSFaix Timothy C · Forest, VABuilt 1969 · S/N 4667 N155RCClark 155 LLC · Missoula, MTS/N 21064312 N155RVVolk Robert N · Talking Rock, GABuilt 2002 · S/N 1728 N155SHSpitzer Helicopter LLC · Woodland Hills, CABuilt 2007 · S/N 4155 N155STAzimi Shahram · Hayward, CABuilt 1964 · S/N TC-651 N155UUtah State University · Logan, UTBuilt 2025 · S/N 40.1251 N155WCTca Equities LLC · Advance, NCBuilt 1981 · S/N TE-1193 N155WWJohnson Otis L · Seminole, TXBuilt 2006 · S/N 2370 N155ZPennsylvania College Of Technology · Williamsport, PABuilt 1981 · S/N TJ-368 N15600Curry Dwain · Apopka, FLBuilt 1972 · S/N 28R-7335073 N15601Wisconsin Fox River Flyers · Milwaukee, WIBuilt 1972 · S/N 28-7310059 N15605Moore Wade O · Eatonville, WAS/N 28-7325112 N15607Mohn Michael A · Ventura, CABuilt 1972 · S/N 28-7325113 N1560EAmerican Airman Inc · Stony Brook, NYBuilt 1978 · S/N 17271047 N1560JShort Christopher · Pine Mountain, GABuilt 1967 · S/N 28-23964 N1560RAbria Consulting LLC · New Milford, NJS/N AA5B-0060 N1560VAvp Aviation LLC · La Jolla, CABuilt 1974 · S/N 17263663 N1560WHigh Performance Aircraft Inc · El Cajon, CABuilt 1997 · S/N E-3097 N1560YPacific Integrated Handling · Tacoma, WABuilt 1994 · S/N TH-1717 N1560ZYoung James Scott · Kemah, TXBuilt 1961 · S/N D-6863 N15610Stull Christopher H · Berrien Springs, MIBuilt 1972 · S/N 28-7305097 N15612Bonnette William A · Gill, MABuilt 1972 · S/N 28-7310060 N15616Jpd Aviation LLC · Newton, NJBuilt 1972 · S/N 28-7305098 N15617Mccary Kenneth W · Mankato, KSS/N 28-7325115 N15618Bankston Dennis G · Concordia, MOBuilt 1972 · S/N 28-7325116 N15619Mrnak Andy M · Bowman, NDS/N 28-7325117 N1561BLamberton Dale F · Brush Prairie, WABuilt 1996 · S/N E-2993 N1561CDoncat LLC · Shelby, MTS/N 30261 N1561GDusky Aviation LLC · Atlanta, GABuilt 1994 · S/N E-2854 N1561LRegistered aircraftBuilt 1994 · S/N E-2856 N1561MWagner Lacy F · Mission Viejo, CABuilt 1989 · S/N CE-1374 N1561RKimmerer William J · Berkeley, CABuilt 1975 · S/N AA5B-0061 N1561TUmanzor Daniel A · S San Fran, CABuilt 1994 · S/N CE-1777 N1561VHenkel Douglas K · Olathe, KSBuilt 1974 · S/N 17263664

Back to AD 2007-04-19 R1