Registered aircraft · 25,370

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N5296RB&R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 17263510 N5297MAllard John R · Circleville, OHS/N 15284518 N5297RWaltman Jack J · Forbes, NDBuilt 1974 · S/N 17263511 N52987Lewis Nathan A Trustee · Watsonville, CABuilt 1978 · S/N 177RG1323 N5298DMorcom Aviation Services Inc DBA · Everett, WABuilt 1979 · S/N 17272500 N5298JBagamaspad Alan M · Reseda, CABuilt 1980 · S/N 17273758 N5298KNew England Aviation LLC · Plainville, CTBuilt 1980 · S/N 17274051 N5298RMurray Wanda Joyce Trustee · Proctor, MTS/N 17263512 N5298VGeorgia Building Solutions LLC · Cleveland, GABuilt 1980 · S/N 172RG0501 N52990Hurley Drew M · Port Orange, FLBuilt 1978 · S/N 177RG1324 N52993Journeys Aviation Inc · Boulder, COBuilt 1981 · S/N 17274654 N5299DPremier Flight Center LLC · Hartford, CTBuilt 1979 · S/N 17272501 N529ADDcm Air LLC · Canton, MIBuilt 1980 · S/N P21000603 N529CANeufeld Don I · Fairview, OKS/N 17269104 N529LFEnterprise Aviation Services LLC · Albuquerque, NMBuilt 1976 · S/N 17267970 N529LSMcnatt Shaun M · Snohomish, WABuilt 1969 · S/N 727-70 N529MCRhoads Eric S · Costa Mesa, CABuilt 1981 · S/N 17274639 N529PAPaccone John E · La Canada, CAS/N 24-1659 N529TDJohnson Timothy Dean · Walton, KYBuilt 1972 · S/N 17260741 N52AJMccarty Aaron T · Wasilla, AKBuilt 1977 · S/N R18200089 N52BJTca LLC · Fountain Hills, AZBuilt 1977 · S/N 177RG1183 N52DBSmith Terry · Cedar Hill, TNS/N 22-1399 N52FFOflanagan Clancy H · Chowchilla, CAS/N 152-82375 N52FSGreseth Harold · Buffalo, MNBuilt 1972 · S/N 426-73 N52GBBurkett Gary L Trustee · Murfreesboro, TNBuilt 1977 · S/N 0761 N52GMSchneider Jeffrey A · Pensacola, FLBuilt 1973 · S/N 70-73 N52GVCompass Aviation Maintenance LLC · Shelby, NCBuilt 1978 · S/N R18200393 N52JXPinhoc Inc · Winter Garden, FLS/N 15281088 N52KKVon Sternbert Nicholas Josef · Valencia, CAS/N 17700563 N52LWN8138l LLC · Metairie, LABuilt 1999 · S/N 840-99 N52MMHappy Sky LLC · Brooklyn, NYS/N 21064870 N52RMStone Patrick S Jr · Houston, TXBuilt 1961 · S/N 1852 N52SEPryor Jeff · Santa Barbara, CABuilt 1978 · S/N P21000080 N53009Triple V Aviation LLC · Long Valley, NJBuilt 1981 · S/N 17274658 N5300ARunzel Brothers Aviation LLC · Bensenville, ILBuilt 1979 · S/N 21063356 N5300KSliviak Thomas V · Leechburg, PABuilt 1980 · S/N 17274053 N53010L & T Aviation Inc · Frederick, MDFirst renewal noticeBuilt 1981 · S/N 17274659 N53017Johnston Charles L II · Nashville, TNBuilt 1981 · S/N 17274663 N5301EMaxwell Don P II · Longview, TXBuilt 1978 · S/N 17271827 N5301HCandace A Larned Enterprises Inc · Long Beach, CABuilt 1979 · S/N 15284083 N53023N53023 Aloha LLC · Palm City, FLBuilt 1981 · S/N 17274665 N53025Beumer Ted Anthony · Pensacola, FLBuilt 1981 · S/N 17274666 N53026Oehl Robert · Jacksonville, FLBuilt 1978 · S/N 177RG1327 N53029N53029 Cardinal LLC · Rosharon, TXBuilt 1978 · S/N 177RG1328 N53035International Air Services Inc Trustee · Carson City, NVBuilt 1978 · S/N 177RG1329 N53036Aviation Gt Inc · Wilmington, DEBuilt 1978 · S/N 177RG1330 N53037Mb Airworks LLC · Palmetto Bay, FLS/N 17274669 N5303EQuinn George F · Amherst, NHBuilt 1978 · S/N 17271829 N5303SKillpack Kevin R · Rio Rancho, NMS/N R18201538 N53045East Hill Flying Club Inc · Ithaca, NYBuilt 1981 · S/N 17274672

Back to AD 80-25-07 R1