Registered aircraft · 63

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

N100BABemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U12 N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40 N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109 N113SHHill Lawrence E · Marion, MTBuilt 1970 · S/N B-18 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N122UCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B32 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N13FPSafeco Leasing LLC · Port Alsworth, AKS/N B-44 N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59 N162MCBank Of Utah Trustee · Salt Lake City, UTS/N B137 N164HAUas Transervices Inc · Boca Raton, FLBuilt 1968 · S/N U-60 N189WAAmeriflight LLC · Dallas, TXBuilt 1969 · S/N U-76 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 N197WAAmeriflight LLC · Dallas, TXBuilt 1970 · S/N U-130 N199CZN199cz LLC · Milwaukee, WIBuilt 1968 · S/N U-30 N207SBBlackbird Aero LLC · Boca Raton, FLS/N B-69 N208SRBardoo Urias L · Massapequa, NYBuilt 1974 · S/N B208 N211VPCentral Virginia Aviation Inc · North Dinwiddie, VAS/N B-2 N219WWTj Air Holdings Inc Trustee · Wilmington, DEBuilt 1975 · S/N B-219 N223LHLelah Holdings Limited Partnership · Reno, NVBuilt 1976 · S/N B-223 N23605Een Aviation LLC · Arlington, TXBuilt 1977 · S/N B-236 N24SPUzochi Inc DBA · Albuquerque, NMBuilt 1972 · S/N BB-3 N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74 N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49 N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135 N3606TSunshine Aero Industries Inc · Crestview, FLBuilt 1970 · S/N B30 N370PRPuerto Rico International Airlines Inc · San Juan, PRBuilt 1969 · S/N B-6 N390RHAlpine Aviation Inc · Provo, UTS/N U-39 N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91 N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2 N431RCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B-71 N450NANational Aerotech Aviation Delaware · Wilmington, DES/N U-92 N479AKSafeco Leasing LLC · Port Alsworth, AKBuilt 1970 · S/N B-96 N499CZN499cz LLC · Milwaukee, WIBuilt 1969 · S/N U-81 N5727Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1970 · S/N B-48 N577DCentral Virginia Aviation Inc · North Dinwiddie, VAS/N B-22 N599CZN599cz LLC · Milwaukee, WIBuilt 1969 · S/N U-89 N70NPBemidji Aviation Services Inc · Bemidji, MNBuilt 1968 · S/N U-14 N711REMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1976 · S/N B-233 N720COscar Charlie LLC · California, MDBuilt 1973 · S/N B-171 N74JVAdvanced Avionics LLC · Cookeville, TNBuilt 1971 · S/N B-74 N776LDodson International Parts Inc · Rantoul, KSBuilt 1970 · S/N B-54 N77PFAerospace Asset Holdings LLC · Wilmington, DEBuilt 1970 · S/N B-70 N781AKAlsworth Glen Sr · Port Alsworth, AKS/N B-53 N7862RUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-85 N799CZN799cz LLC · Milwaukee, WIBuilt 1969 · S/N U-68

Back to AD 74-16-03