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.

N29HCInternational Air Services Inc Trustee · Carson City, NVS/N 3449073 N29MFChas N Clark Associates Ltd · Laurel, MSBuilt 2000 · S/N TH-1966 N29RKRhk Of Kansas Inc · Jefferson City, MOBuilt 1982 · S/N TC-2451 N29RRKhg Aviation Holdings LLC · Columbus, OHBuilt 1982 · S/N TJ-414 N29XXMustang Aeronautics LLC · Chandler, AZBuilt 1975 · S/N 421C0035 N2AVRegistration Pending · Scottsdale, AZRegistration pendingBuilt 1985 · S/N 20800057 N2BBLowry Air LLC · Tahlequah, OKBuilt 1972 · S/N TC-1447 N2CFKentucky Aviation Solutions LLC · Frankfort, KYS/N 340A0319 N2FXPlane Crazy Aviation LLC · Hollywood, SCBuilt 1966 · S/N 27-3147 N2GPPlanes Of Fame Air Museum · Chino, CAS/N P-56 N2HRWertheim Michael S · Fort Pierce, FLBuilt 1974 · S/N 27-7405342 N2HSIsland Pearl Airways · Doral, FLFirst renewal noticeBuilt 1979 · S/N 34-8070022 N2JAJadair International Inc · Port Washington, WIBuilt 1976 · S/N 421C0154 N2KMBas Part Sales LLC · Greeley, COBuilt 1973 · S/N TC-1608 N2LYMagnolia Air LLC · Starkville, MSS/N 421C0301 N2PJMorgan Bryan K · Sacramento, CABuilt 1969 · S/N 337-1161 N2PNFugro USA Land Inc · Rapid City, SDBuilt 1977 · S/N 31-7752141 N2PWXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 44-7995087 N2QWPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754126 N2RPFasken Frank Andrew · Paris, TXS/N 27-7754160 N2UTDemaeyer Thomas A · Fort Lauderdale, FLBuilt 1969 · S/N TC-1203 N2VGWong Jonathan · Phoenix, AZBuilt 1969 · S/N 30-1875 N2VQN2vq LLC · Manassas, VABuilt 1964 · S/N 30-563 N2VVAir Mods And Repair Inc · Robbinsville, NJBuilt 1976 · S/N TK-37 N2XHAmericas Best Amt Inc · Goodyear, AZBuilt 1964 · S/N 30-473 N2XRInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 318152014 N2XXTyler James · Oklahoma City, OKS/N 310L0182 N2YCTaglavore Franklin · Irving, TXBuilt 1974 · S/N TH-487 N2YPCollum Aviation LLC · Milton, FLS/N 30-452 N3000FNosense LLC · Kalispell, MTS/N 34-7970044 N30028Cc Aviation Inc · Tracy, CAS/N 34-48019 N3003L310-J Enterprises Inc · Parkland, FLBuilt 1965 · S/N 310J0003 N3005DAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1978 · S/N 44-7995140 N3007WLima Mike Inc · Ham Lake, MNBuilt 1973 · S/N TH-365 N300BMohave Maverick Aviation LLC · Bullhead City, AZBuilt 1966 · S/N TC-1001 N300BRMach Tuck Aero Group LLC · Elkhorn, NES/N 421C0453 N300CGAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1978 · S/N 414A0121 N300DESchmidt Arthur J · Tampa, FLS/N 34-7770157 N300EJPartwin LLC · Greenwich, CTBuilt 1974 · S/N 310Q1156 N300JNK-M Air Enterprises Inc · Corona, CABuilt 1973 · S/N TC-1634 N300JTMentor Capital LLC · San Antonio, TXBuilt 1978 · S/N 34-7970074 N300MBIglesia De Cristo · Porter Ranch, CABuilt 1974 · S/N 421B0573 N300MMHamblin Kenneth · Stanton, TNBuilt 1965 · S/N 30-851 N300NEBoone Steven E · Harrison, TNBuilt 1968 · S/N TC-1172 N300REMoreau Leo B · Wasilla, AKBuilt 1965 · S/N 30-841 N300SQVortex Aviation LLC · Houston, TXBuilt 1979 · S/N 414A0416 N300SRLevenson Louis · Atlanta, GABuilt 1981 · S/N 31T-8104022 N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266 N300WAThunderbolt Air LLC · Granbury, TXBuilt 1968 · S/N 31-294 N300WPPcp Aviation LLC · Miramar Beach, FLBuilt 1978 · S/N 31T-7904006

Back to AD 2004-25-16 R1