Registered aircraft · 362

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:77-07-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-07-06') 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:77-07-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-07-06')
  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:77-07-06')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:77-07-06')
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 N10WG10wg LLC · Newman Lake, WABuilt 1978 · S/N LW-310 N10XJNext Phase Ia LLC · Las Vegas, NVS/N LW-117 N110BMDrewcy Inc · Wilmington, DEBuilt 1978 · S/N LW-273 N111JAMillennium Falcon 2020 LLC Trustee · Wilmington, DEBuilt 1974 · S/N LW-84 N111TCGrady Excavating Inc · Mukilteo, WABuilt 1978 · S/N LW-305 N112HGAlghazzawi Hani · Toledo, OHS/N LJ529 N115YSTunnell Darrell · Visalia, CABuilt 1974 · S/N LW126 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 N11DTAzul Air LLC · Dover, DEBuilt 1972 · S/N LW-11 N11SNSsj Holdings LLC · Modesto, CABuilt 1982 · S/N LJ-1036 N1205SCounty Line Aviation LLC · Benton, KSBuilt 1979 · S/N LW-319 N121BArgo Aviation LLC · Potsdam, NYBuilt 1972 · S/N LW-21 N121JGGo Consultants LLC · Wilmington, DES/N LJ-996 N122KMerlin Labs Inc · Boston, MABuilt 1976 · S/N LJ-707 N123MHBryan-Kennedy LLC · Tulsa, OKBuilt 1974 · S/N LW-104 N125NJAircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1982 · S/N LJ-1045 N126WAJpg & Aog LLC · Concord, NCBuilt 1984 · S/N LJ1093 N12AXEsc-100 Executive Consulting Services LLC · Pharr, TXBuilt 1978 · S/N LW-293 N12GJBuilding Ideas Inc · Los Gatos, CABuilt 1972 · S/N LW-12 N12LACentral Virginia Aviation Inc · Petersburg, VAS/N LW-49 N132HSCentral Virginia Aviation Inc · Petersburg, VABuilt 1972 · S/N LW-8 N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N14NMDriscoll Health Care Services · Corpus Christi, TXBuilt 1973 · S/N LW-35 N14SBMountain Air Aviation LLC · Jonesville, VAS/N LW-214 N150TWCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1973 · S/N LW-50 N150VECarnes 150ve LLC · Wichita Falls, TXBuilt 1975 · S/N LJ-678 N152WWNardi Greg · Missoula, MTS/N LJ-654 N155LSRainair Avionics Services LLC · Albertville, ALS/N LW-286 N156GAlliance Air Parts Acquisitions Corp · Oklahoma City, OKBuilt 1975 · S/N LW-156 N157MHMile Hi Skydivers Inc · Longmont, COS/N LW157 N162STState Of Michigan · Lansing, MIBuilt 1978 · S/N LW-300 N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054 N175AZSparrow Group LLC · Cheyenne, WYBuilt 1981 · S/N LJ-1006 N176JRKimmel Aviation Insurance Agency Inc · Greenwood, MSBuilt 1974 · S/N LW-115 N176TWSierra American Corporation · Wilmington, DEBuilt 1974 · S/N LW-76 N177MKTrans Equipment Svcs Inc · Greenville, SCBuilt 1975 · S/N LW-149 N17NMCentral Virginia Aviation Inc · Petersburg, VABuilt 1977 · S/N LW-237 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 N190BETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1981 · S/N LW-345 N190EFTriple E Farms LLC · Pasco, WABuilt 1985 · S/N LJ-1122 N190RLCamair Leasing LLC · Granbury, TXBuilt 1972 · S/N LW-1

Back to AD 77-07-06