Registered aircraft · 728

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:81-23-01-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:81-23-01-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:81-23-01-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:81-23-01-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:81-23-01-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:81-23-01-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.

N12LACentral Virginia Aviation Inc · Petersburg, VAS/N LW-49 N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80 N131BABemidji Aviation Svcs Inc · Bemidji, MNBuilt 1966 · S/N LD-297 N132BABemidji Aviation Services Inc · Bemidji, MNS/N LD-331 N132HSCentral Virginia Aviation Inc · Petersburg, VABuilt 1972 · S/N LW-8 N134BABemidji Aviation Svc Inc · Bemidji, MNBuilt 1964 · S/N LD-202 N136PAX-Press Charter Service Inc · Longview, TXBuilt 1975 · S/N LJ662 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N139JBQuay Ventures LLC · Alto, TXBuilt 1979 · S/N BE-81 N139SCNew Ulm C90 LLC · Marshall, MNBuilt 1979 · S/N LJ868 N13FPSafeco Leasing LLC · Port Alsworth, AKS/N B-44 N140PAJump Plane Of Pittsburgh LLC · Mercer, PABuilt 1967 · S/N LJ-297 N142TPGeorgia Florida Aviation Search Team · Monticello, FLBuilt 1962 · S/N LF-71 N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59 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 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 N15CTSkydive Grand Haven LLC · Grand Haven, MIBuilt 1966 · S/N LJ-192 N162MCBank Of Utah Trustee · Salt Lake City, UTS/N B137 N162STState Of Michigan · Lansing, MIBuilt 1978 · S/N LW-300 N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60 N167BBCentral Virginia Aviation Inc · Petersburg, VABuilt 1983 · S/N LJ-1054 N175AZSparrow Group LLC · Cheyenne, WYBuilt 1981 · S/N LJ-1006 N175RCCbp Air Logistics LLC · Statham, GABuilt 1976 · S/N BE-3 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 N184BABemidji Aviation Services Inc · Bemidji, MNBuilt 1962 · S/N LF-68 N187ALAlm Holdings Delaware 2 LLC · Wilmington, DES/N LJ842 N188Gear Robert Lee III · Paradise Valley, AZS/N LC70 N188LLTriple Aviation LLC · San Leon, TXBuilt 1981 · S/N BE-119 N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76 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 N191JRLocke-Lane Aviation LLC · Statesville, NCBuilt 1975 · S/N LW144 N191WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U136 N1924TUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-115 N192WAAmeriflight LLC · Dallas, TXBuilt 1973 · S/N U152 N197CANighthawk Air Systems Inc · Miami, FLBuilt 1965 · S/N LD-246

Back to AD 81-23-01 R1