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.

N747WWN Registration Services LLC Trustee · Sanford, NCS/N 27-4330 N7482WSkys Edge Aviation LLC · Midland, TXS/N 27-3524 N7485YCline Aircraft LLC · Mena, ARBuilt 1964 · S/N 30-546 N7486YGardner Canaan · Chandler, OKBuilt 1964 · S/N 30-547 N748CADesert Air Ambulance Inc · Menifee, CABuilt 1980 · S/N 421C0905 N748DAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1980 · S/N ME-341 N748XMorgan Bryon E · Eugene, ORS/N 3370029 N7492NTurner Jimmy A · San Antonio, TXBuilt 1968 · S/N TC-1125 N74932Ruocco 220 LLC · Escondido, CABuilt 1973 · S/N 31-7305074 N7494YRay James O III · Mc Rae, GABuilt 1964 · S/N 30-555 N74972H&H Aircraft LLC · Grey Eagle, MNBuilt 1973 · S/N 31-7305123 N749CABig Bear Resorts Inc · Big Bear Lake, CAS/N 421C1239 N749LWLease One LLC · Lafayette, INBuilt 1977 · S/N 347770416 N749SDewitt Scott · Corpus Christi, TXBuilt 1964 · S/N 320C0016 N74ABAerial Digital Images LLC · Huntington Beach, CABuilt 1959 · S/N 23-1656 N74BBHy Aviation LLC · San Juan, PRBuilt 1971 · S/N 27-4750 N74BNBig Bend Community College Foundation · Moses La, WABuilt 1969 · S/N 30-1806 N74DDN74dd Inc · Apalachicola, FLBuilt 1978 · S/N 31-7952016 N74ETThompson Howard Earle Jr · Dadeville, ALS/N TC-619 N74HJRegistration Pending · Sheridan, WYRegistration pendingBuilt 1974 · S/N 340-0333 N74LCommunity And Faith Initiatives · Phoenix, AZBuilt 1977 · S/N 33701814 N74LKAlexander 3 Aviation LLC · Rincon, GAS/N 31-8012038 N74LRRemy Lange · East Greenville, PAS/N 27-7405363 N74MFCarl Raymond Baker LLC · Brenham, TXBuilt 1981 · S/N TJ-397 N74MJFord Richard M · Cartersville, GABuilt 1977 · S/N 31-7712065 N74MPRegistration Pending · Bargersville, INRegistration pendingS/N 34-7770194 N74PBBaranko Peter A · Meridian, IDBuilt 1981 · S/N 414A0828 N74PLAncient Pelican Aviation LLC · Vero Beach, FLS/N 27-7405272 N74WMTurnage Leon G · Weatherford, TXBuilt 1975 · S/N TH-653 N74WTOrriserv LLC · Prior Lake, MNBuilt 1981 · S/N 34-8133253 N74YCButzer Brian K · Boca Raton, FLBuilt 1969 · S/N 30-1847 N7503YCunneen Sean M · Vista, CABuilt 1964 · S/N 30-565 N7505QJohnson Michael L · Jefferson, TXBuilt 1969 · S/N 310Q0005 N750AURunamuck LLC · New Orleans, LABuilt 2025 · S/N 4496619 N750HKRegistration Pending · Lutz, FLRegistration pendingS/N 30-947 N750PCMarilyn Merlot LLC · Kalispell, MTBuilt 1972 · S/N 340-0189 N750RTBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2021 · S/N 4496529 N7510DK & A Duke LLC · Marcellus, MIBuilt 1969 · S/N P-101 N7510QOne Zero Q LLC · Mount Pleasant, MIBuilt 1969 · S/N 310Q0010 N75120Kratzer Edgar · New Port Richey, FLBuilt 1976 · S/N 34-7670224 N7512QGorge Winds Aviation Inc · Fairview, ORBuilt 1969 · S/N 310Q0012 N7515YJohnson Max L Jr · Greenville, SCBuilt 1964 · S/N 30-579 N7517QQuay Ventures LLC · Alto, TXBuilt 1969 · S/N 310Q0017 N7519YDunshee Kevin G · La Luz, NMBuilt 1964 · S/N 30-584 N751WWVicentin De Oliveira Ricardo · Winter Garden, FLBuilt 1967 · S/N 30-1449 N7520YWendelburg Kevin R · Moreland, GABuilt 1964 · S/N 30-585 N7523YBarry Patric · Laguna Hills, CABuilt 1964 · S/N 30-588 N7525QBuckin Donald L · Phoenix, AZS/N 310Q0025 N7526QWhat A Day To Travel LLC · Edgerton, WIS/N 310Q0026 N7528YSkyward Solutions Inc · Lewes, DEBuilt 1964 · S/N 30-593

Back to AD 2004-25-16 R1