Registered aircraft · 286

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

N100KBExecutive Air Taxi Corp · Bismarck, NDBuilt 1979 · S/N LJ-820 N100QTSouthwest Aviation Inc · Marshall, MNBuilt 1976 · S/N LJ689 N100VReserve Aviation LLC · Dallas, TXBuilt 1978 · S/N LJ-796 N100WBBbcc Foundation · Moses Lake, WABuilt 1966 · S/N LJ-139 N101BSOn Mission Network · Dallas, TXBuilt 1968 · S/N LJ-375 N110ELForsyth Technical Community College · Winston Salem, NCBuilt 1965 · S/N LJ-71 N112HGAlghazzawi Hani · Toledo, OHS/N LJ529 N115PACentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-117 N11638N3701d LLC · Wilmington, NCBuilt 1983 · S/N LJ-1052 N11692Vertical Transit Corp · Luling, TXBuilt 1978 · S/N LJ772 N117MFJet Sales Of Stuart LLC · Stuart, FLBuilt 1978 · S/N LJ-779 N11SNSsj Holdings LLC · Modesto, CABuilt 1982 · S/N LJ-1036 N121JGGo Consultants LLC · Wilmington, DES/N LJ-996 N122KMerlin Labs Inc · Boston, MABuilt 1976 · S/N LJ-707 N125NJAircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1982 · S/N LJ-1045 N126WAJpg & Aog LLC · Concord, NCBuilt 1984 · S/N LJ1093 N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129 N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N140PAJump Plane Of Pittsburgh LLC · Mercer, PABuilt 1967 · S/N LJ-297 N14VDouble D International LLC · Miami, FLS/N LJ-411 N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678 N152WWNardi Greg · Missoula, MTS/N LJ-654 N15CTSkydive Grand Haven LLC · Grand Haven, MIBuilt 1966 · S/N LJ-192 N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054 N175AZSparrow Group LLC · Cheyenne, WYBuilt 1981 · S/N LJ-1006 N1801BSjd Flight LLC · Houston, TXBuilt 1974 · S/N LJ-634 N183SADriscoll David A · Savannah, TNBuilt 1973 · S/N LJ571 N187ALAlm Holdings Delaware 2 LLC · Wilmington, DES/N LJ842 N18MYWorld Aircraft Leasing Inc · Wilmington, DES/N LJ562 N190EFTriple E Farms LLC · Pasco, WABuilt 1985 · S/N LJ-1122 N198KAThompson Benjamin Kyle · Nevada, TXBuilt 1966 · S/N LJ-162 N1GFFlowers George D · Panama City, FLBuilt 1982 · S/N LJ1031 N2000EBluebird 2000 LLC · Wilmington, DEBuilt 1966 · S/N LJ-172 N2050ATia Aeronautics Inc · Harlingen, TXBuilt 1978 · S/N LJ-813 N205MSJustice Air Inc · Farmingdale, NYBuilt 1981 · S/N LJ-948 N205STPate & Pate Air LLC · Andalusia, ALBuilt 1981 · S/N LJ-965 N20WPMoser Aircraft Service LLC · Huntington, INBuilt 1977 · S/N LJ-738 N210ECState Of Tennessee · Nashville, TNBuilt 1984 · S/N LJ-1070 N214PNavajo Nation · Window Rock, AZBuilt 1991 · S/N LJ-1293 N227DCEllen Vineyards Inc · Sanger, CABuilt 1979 · S/N LJ876 N22BBSpillman Robert · Port Orange, FLBuilt 1967 · S/N LJ-241 N246CKMccarty David M · Baker City, ORBuilt 1976 · S/N LJ694 N249CPAngels Envy Aviation LLC · Denison, TXBuilt 1979 · S/N LJ-841 N267COldham Matthew Stephen · Lewisville, TXBuilt 1980 · S/N LJ-896 N268CACaruthers LLC · Moundville, ALBuilt 1978 · S/N LJ-759 N26RERrr Aviation LLC · Gulfport, MSBuilt 1975 · S/N LJ-676 N270MNardi Greg P · Missoula, MTBuilt 1967 · S/N LJ-288 N278SWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1982 · S/N LJ-1011 N284PMArtic Legacy Aviation LLC · Anchorage, AKBuilt 1977 · S/N LJ734

Back to AD 2000-02-15