OpenAirDocs.org
AD 73-20-07 R2

Registered aircraft · 1,348

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

N8757MHolmes Charles E · South Bend, INBuilt 1963 · S/N M-545N8758MAndrew Manuel Driscoll · South Yarmouth, MABuilt 1964 · S/N M-546N8760MRegistration Pending · Cheney, WARegistration pendingS/N M-548N8761MJohnson Gregory J · Port Orange, FLS/N M-549N8763MHaugh Mervin E III · Red Lion, PABuilt 1965 · S/N M-802N8764MRegistration Pending · Rome, GARegistration pending, canceledS/N M-132N8773MSexton Jonathan B · Claremore, OKBuilt 1964 · S/N M-558N8775MRio Aviation LLC · Wilmington, DES/N M-591N8778MSchroemer Theodore J · High Point, NCBuilt 1963 · S/N M-208N8780MTurner Michael T · Kernersville, NCS/N M-564N8782MZimpel Kurt S DBA · Hinckley, MNBuilt 1964 · S/N M-567N8792MWilkinson Larry E · Santa Rosa Beach, FLBuilt 1964 · S/N M-575N8796MRegistration Pending · Russell Springs, KYRegistration pendingBuilt 1964 · S/N M-579N8857MDunn Brady · Gilmer, TXS/N M-597N8859MParylak Sean P · Colchester, CTBuilt 1964 · S/N M-598N8862MChavers Investments LLC · Cantonment, FLBuilt 1964 · S/N M-595N8863MBrainerd Philip S · Lake Placid, FLS/N M-599N8864MBlue Aviation LLC · Franklin, TNBuilt 1964 · S/N M-602N8866MZayatz Carl A · Lansing, MIBuilt 1964 · S/N M-604N8868MBas Part Sales LLC · Greeley, COBuilt 1964 · S/N M-606N8875MChestnutt Michael L · Clinton, NCBuilt 1964 · S/N M-619N8876MLohman Curtis · Shelby, MIBuilt 1964 · S/N M-618N8879MN8879m LLC · Lakeview, NCS/N M-626N8880MAv8r Hub Inc · Jacksonville, FLS/N M-627N8884MWomack David B · Hurst, TXBuilt 1964 · S/N M-633N8885MBulls Chris · Rising Fawn, GABuilt 1964 · S/N M-634N8887MTcb Aviation Inc · Knoxville, TNBuilt 1964 · S/N M-631N8889MLong Jarod H · Satsuma, ALBuilt 1964 · S/N M-635N8890MShake Justin N · Johnson City, TNBuilt 1964 · S/N M-641N8892MTaylor Charles D · Dillon, SCBuilt 1965 · S/N M-643N8894MGarcia Luis · Plantation, FLS/N M-645N8895MMejias Seth · Astoria, NYBuilt 1964 · S/N M-647N8897MAlmeter Francis J · Lebanon, ILBuilt 1965 · S/N M-648N88SWBoline Lonny R · Lincoln, MEBuilt 1970 · S/N MB-500N8930MCuratola Bruce J · League City, TXS/N M-318N89JBEspelien Jay A · Sartell, MNBuilt 1981 · S/N M-2242N8NDSmith Dane S · Berlin Heights, OHBuilt 1971 · S/N MB-514N9107TVaughan Lee E Jr · Philip, SDBuilt 1968 · S/N MB-377N9114TFlying Frog Aviation LLC · Palm City, FLBuilt 1969 · S/N MB-401N9116TSkinner Jay D · The Woodlands, TXBuilt 1968 · S/N MA-331N9119TDahab Richard E · Brightwaters, NYBuilt 1968 · S/N MA-333N9127TSimon William Corey · Fruita, COS/N M-1148N9139TBoss Peter J · Bruce, WIBuilt 1968 · S/N M-1155N9140TKay Aviation LLC · Merritt Island, FLBuilt 1968 · S/N M-1156N9143SBooton Charles E · Navarre, FLBuilt 1975 · S/N MC-397N9145SJuhl Christian B · Boynton Beach, FLBuilt 1976 · S/N M-1768N9148SBlue Skies Aviation LLC · Holland, MIS/N MB-787N914GPRoy Dino · Saginaw, TXBuilt 1966 · S/N MA-124N9152SHomer Mark · Grosse Ile, MIBuilt 1975 · S/N MC-399N9153SB Squared Inc · Bedford, NHBuilt 1976 · S/N MC-400
Back to AD 73-20-07 R2