Registered aircraft · 110

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:72-20-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:72-20-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:72-20-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:72-20-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:72-20-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:72-20-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 N100WBBbcc Foundation · Moses Lake, WABuilt 1966 · S/N LJ-139 N101BSOn Mission Network · Dallas, TXBuilt 1968 · S/N LJ-375 N108BABemidji Aviation Services Inc · Bemidji, MNS/N U-40 N109CZN109cz LLC · Milwaukee, WIBuilt 1969 · S/N U-109 N110ELForsyth Technical Community College · Winston Salem, NCBuilt 1965 · S/N LJ-71 N115PACentral Virginia Aviation Inc · North Dinwiddie, VAS/N LJ-117 N118MDAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U-118 N128SFWin Win Aviation Inc · Wake Forest, NCBuilt 1969 · S/N U-87 N129LABluebird 2000 LLC · Wilmington, DES/N LJ-129 N130BABemidji Aviation Services Inc · Bemidji, MNBuilt 1969 · S/N U-80 N137BABemidji Aviation Services Inc · Bemidji, MNBuilt 1970 · S/N U137 N140PAJump Plane Of Pittsburgh LLC · Mercer, PABuilt 1967 · S/N LJ-297 N14MVAlpine Aviation Inc · Provo, UTBuilt 1969 · S/N U59 N14VDouble D International LLC · Miami, FLS/N LJ-411 N15CTSkydive Grand Haven LLC · Grand Haven, MIBuilt 1966 · S/N LJ-192 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 N198KAThompson Benjamin Kyle · Nevada, TXBuilt 1966 · S/N LJ-162 N199CZN199cz LLC · Milwaukee, WIBuilt 1968 · S/N U-30 N2000EBluebird 2000 LLC · Wilmington, DEBuilt 1966 · S/N LJ-172 N20FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-111 N21FWUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-117 N22BBSpillman Robert · Port Orange, FLBuilt 1967 · S/N LJ-241 N270MNardi Greg P · Missoula, MTBuilt 1967 · S/N LJ-288 N290CCMonument Aviation LLC · North Chesterfield, VABuilt 1966 · S/N LJ132 N292APlacebo Air LLC · Ridgecrest, CABuilt 1966 · S/N LJ-99 N299CZN299cz LLC · Milwaukee, WIBuilt 1969 · S/N U74 N2UVDependable Freight LLC · Bethel, AKBuilt 1969 · S/N LJ-480 N312VFCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ-299 N31TNLake Clark Air Inc · Port Alsworth, AKBuilt 1969 · S/N U49 N321DZNardi Greg · Missoula, MTBuilt 1968 · S/N LJ-367 N325RRCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1967 · S/N LJ-289 N326CAAlpine Aviation Inc · Provo, UTBuilt 1970 · S/N U-135 N32BAPittsburgh Skydiving Jump Plane LLC · Mercer, PABuilt 1969 · S/N LJ-475 N33SBPittsburgh Institute Of Aeronautics · West Mifflin, PABuilt 1967 · S/N LJ-252 N34AKUas Transervices Inc · Boca Raton, FLBuilt 1969 · S/N U-105 N390RHAlpine Aviation Inc · Provo, UTS/N U-39 N394ALTeebird Enterprises LLC · Brighton, COBuilt 1968 · S/N LJ394 N399CZN399cz LLC · Milwaukee, WIBuilt 1969 · S/N U-91 N39TNDenaina Leasing Agency LLC · Anchorage, AKBuilt 1968 · S/N U-2 N3DFTaurman Keith L · Virginia Beach, VABuilt 1965 · S/N LJ-36 N3XBMonument Aviation LLC · North Chesterfield, VABuilt 1967 · S/N LJ-234 N40BA711bn LLC · Miami, FLBuilt 1969 · S/N LJ-444 N411FTUS Aviation Corp · Miami, FLBuilt 1969 · S/N LJ-443 N416MRJosephine Air LLC · Castle Rock, WABuilt 1967 · S/N LJ-267

Back to AD 72-20-03