Registered aircraft · 2,358

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:98-15-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-15-13') 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:98-15-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-15-13')
  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:98-15-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-15-13')
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.

N135MKRio Frio Leasing Co LLC · Houston, TXBuilt 1984 · S/N FA-3 N135SSTextron Aviation Inc · Wichita, KSS/N FM-135 N136KFFisher Auto Parts Inc · Staunton, VABuilt 2016 · S/N FL-1036 N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662 N137FLCharlie-001 LLC · Sugar Grove, ILBuilt 1996 · S/N FL137 N138MMTextron Aviation Inc · Wichita, KSS/N FM-138 N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N13GZGuardian Flight LLC · South Jordan, UTBuilt 2000 · S/N LJ-1590 N140HAxis Transportation Services LLC · Sacramento, CABuilt 2005 · S/N LJ-1753 N140MCPlane To Sea LLC · Raleigh, NCBuilt 1996 · S/N FL-140 N140MNTextron Aviation Inc · Wichita, KSS/N FM-140 N140PAJump Plane Of Pittsburgh LLC · Mercer, PABuilt 1967 · S/N LJ-297 N140RLN140rl LLC · Kalispell, MTBuilt 1982 · S/N BT22 N141LVictor One Four One LLC · Boston, MABuilt 2007 · S/N FL-524 N141SMInfinity Aeronautics LLC · Greer, SCBuilt 1984 · S/N FA-23 N141SULynch Family Companies Inc · Waucoma, IABuilt 2022 · S/N FL-1308 N142EBFly Me LLC · Mc Gregor, TXBuilt 1982 · S/N BB-1042 N142MNTextron Aviation Inc · Wichita, KSS/N FM-142 N143FWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2000 · S/N LJ-1612 N143NDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N FM-103 N143TAJrr Motor Sales LLC · Campbellsville, KYBuilt 1984 · S/N BB-1183 N144CMeyers Construction Inc · Fresno, CABuilt 1991 · S/N FL-49 N1459General Atomics Aeronautical Systems Inc · San Diego, CABuilt 2009 · S/N FL-667 N145AFDale Aviation Inc · Rapid City, SDS/N LJ-1721 N146LCSaratoga Homes Of Texas San Antonio LLC · El Paso, TXBuilt 1982 · S/N BB1046 N147LJGuardian Flight LLC · Lewisville, TXS/N LJ-1476 N148AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N FM-12 N149CCCianbro Corp · Baltimore, MDS/N FA-145 N14HHDelaware Professional Aviation LLC · Dalton, GABuilt 1988 · S/N BB-1286 N14NGFirst Avenue Management LLC · Savannah, GABuilt 1987 · S/N BB-1276 N14NMDriscoll Health Care Services · Corpus Christi, TXBuilt 1973 · S/N LW-35 N14SBMountain Air Aviation LLC · Jonesville, VAS/N LW-214 N14VDouble D International LLC · Miami, FLS/N LJ-411 N150CNKing Air Investments LLC · Ferriday, LABuilt 1981 · S/N LA-138 N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531 N150GXWest Penn Aviation LLC · Midland, TXBuilt 2008 · S/N FL592 N150RFR & F Wings III LLC · Liverpool, NYBuilt 2015 · S/N FL-1023 N150RLTigress Air III LLC · California, MDBuilt 1982 · S/N BL-50 N150TWCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-50 N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678 N150YDSfh Inc DBA · Fargo, NDBuilt 1997 · S/N BB-1561 N151QDepartment Of Homeland Security · Washington, DCBuilt 2015 · S/N FM-59 N151WTKo Aviation LLC · Wilmington, DEBuilt 1983 · S/N BB-1151 N152WWNardi Greg · Missoula, MTS/N LJ-654 N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366 N154KFRegistered aircraftBuilt 2016 · S/N FL-1054 N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204 N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206 N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214

Back to AD 98-15-13