Registered aircraft · 10,537

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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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:2004-25-16-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.

N6573YClendenen William M · Spencer, TNBuilt 1968 · S/N 27-3871 N6578AAir Mods And Repair Inc · Robbinsville, NJBuilt 1978 · S/N 27-7954013 N6578CPapoose Air II LLC · Wilmington, DEBuilt 1978 · S/N 414A0020 N6579YTaco Tyme LLC · Hobe Sound, FLBuilt 1968 · S/N 27-3878 N657WMRegistration Pending · Carlsbad, NMRegistration pendingS/N 421C0474 N6582Phoenix Aviation LLC · Bonaire, GABuilt 1976 · S/N 340A0125 N6588ARasch Kevin Wayne · Denton, TXS/N 27-7954015 N6588YSo Flipping Busy LLC · Apple Valley, MNBuilt 1968 · S/N 27-3891 N658DGSchardt Aaron · Hastings, NEBuilt 1981 · S/N TH-1324 N658JSTwo River Airspray LLC · Cavalier, NDBuilt 1977 · S/N TJ100 N658MWitherington Properties Inc · Oak Ridge, TNBuilt 1982 · S/N TJ429 N6593UWedt LLC · Wilmington, DEBuilt 1983 · S/N TH-1371 N6597CHai Services Inc · Haltom City, TXBuilt 1978 · S/N 414A0028 N6598LAtmospheric Corrosion Specialists Inc · Mechanicsburg, PABuilt 1969 · S/N 31-483 N6599GPremiere Aviation Inc · Concord, CAS/N 421C0275 N659RJFoerstel Edward · Miami Beach, FLBuilt 1984 · S/N 421C1408 N65AEMorris Charles J · Rutherford, TNBuilt 1975 · S/N 421B0953 N65BATts Leasing Inc · Kansas City, KSBuilt 1980 · S/N 31T-8020071 N65CGAirplanesusa LLC · Schaumburg, ILBuilt 1981 · S/N 34-8233004 N65CLCl415 Aviation Salvage LLC · Belgrade, MTFirst renewal noticeS/N 1065 N65CMCapital City Jet Center Inc · Somerset, OHBuilt 1978 · S/N 31-7852077 N65DBrowndog LLC · Lksid Marblhd, OHBuilt 1972 · S/N 3400092 N65DFAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1964 · S/N 27-2553 N65DMCorry Aviation LLC · Tequesta, FLBuilt 1973 · S/N 27-7305005 N65GSCheyenne Air LLC · Charleston, WVBuilt 1983 · S/N 31P-8414016 N65LMAero Compression LLC · Macon, GABuilt 1999 · S/N TH-1902 N65MH993 LLC · Davidson, NCS/N TH-2050 N65MJPlane Fun Inc Tr Trustee · Snellville, GABuilt 1985 · S/N TJ-487 N65MMShewbart Keith M · Crystal River, FLBuilt 1969 · S/N 337M0446 N65PFInternational Air Services Inc Trustee · Carson City, NVS/N 30-1515 N65RPE-Co Aviation LLC · Wilmington, DEBuilt 1979 · S/N 414A0287 N65SCDocs Air LLC · Buffalo, WYBuilt 1974 · S/N 27-7405445 N65SDBlankenship Royce J · Daytona Beach, FLBuilt 1967 · S/N 30-1431 N65WROneill Patrick John · Red Wing, MNS/N TC-923 N6601LUnited Jet Sales Inc · Newark, DEBuilt 1977 · S/N 27-7854047 N660ACSmooth Air LLC · Richboro, PABuilt 1977 · S/N 31-7752142 N660BBKeys Vacation Rentals LLC · Palm City, FLBuilt 1966 · S/N 27-3472 N660CKPrecision Delta Corp · Ruleville, MSBuilt 1979 · S/N TH-1079 N6613YAviation Group Jmj Inc · Callahan, FLExpired dealer, pending cancellationBuilt 1969 · S/N 27-4395 N6614CBg Air Corp · Wilmington, DEBuilt 1978 · S/N 414A0032 N6617NSeal William T · Eagle, IDBuilt 1983 · S/N TH-1373 N661DAHalladay Roy · Erie, COBuilt 1964 · S/N TC-807 N661KQDaybreak Aviation LLC · Wellington, ALS/N TC-2293 N661WLButterbar Leasing LLC · Virginia Beach, VABuilt 1984 · S/N TH-1404 N6621YDyka Samuel M · Flushing, MIBuilt 1969 · S/N 27-4397 N6623YOrtner Airport LLC · Wakeman, OHBuilt 1968 · S/N 27-3930 N6625DFox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-203 N66265Russo James F · Hilton Head Island, SCBuilt 1979 · S/N ME-207 N66272Fox Valley Technical College · Oshkosh, WIBuilt 1979 · S/N ME-216 N6627XIsiah 4031 LLC · Quakertown, PABuilt 1979 · S/N ME-215

Back to AD 2004-25-16 R1