OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,028

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:72-03-03-R3')
    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-03-03-R3')
  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.

N8356UKolb Austin R · Phoenixville, PABuilt 1964 · S/N 17252256N8357KBaldasaro Bonnie B · Clifton Park, NYS/N 15070575N8358JMorrow John E · Clarendon, TXBuilt 1967 · S/N 15066258N8358LOc Flight Lessons LLC · Costa Mesa, CABuilt 1968 · S/N 17256558N8358SStewart Bryan P · Carson City, NVBuilt 1965 · S/N 18256458N8358UN8358u LLC · Knoxville, IABuilt 1964 · S/N 17252258N8359JManchester Eric S · Milton, VTBuilt 1967 · S/N 15066259N8359LBay Lux Ventures LLC · Tampa, FLS/N 17256559N8359UMusgrove Stacy J · Cunningham, TXS/N 17252259N835MDMacconnell John · Deland, FLBuilt 1963 · S/N 18254759N8360MOld Goat Aviation LLC · Naples, FLBuilt 1969 · S/N A1500060N8361JCoughlin Kevin P · Ridge, NYBuilt 1967 · S/N 15066261N8361LMolid Robert J · Dubuque, IABuilt 1968 · S/N 17256561N8361UBoss Gary W · Bronston, KYS/N 17252261N8361ZVining Eric · Lowell, ARS/N 205-0361N8362UJohnson Scott T · Delta, UTS/N 17252262N8362ZCampbell Tyler A · Billings, MTBuilt 1963 · S/N 205-0362N8363SHellie Andrew Bryant · College Place, WAS/N 18256463N8363URagsdale Gregory · Peoria, AZS/N 17252263N8364MComchoc Paul R · Bellevue, WABuilt 1969 · S/N A15000064N8364UElite Fleet Jacksonville LLC · Jacksonville, FLBuilt 1964 · S/N 17252264N8365GMendez Carlos L · Somerset, NJBuilt 1965 · S/N 15062465N8365LHarbour Aviation LLC · Weatherford, TXBuilt 1968 · S/N 17256565N8365UHunt Ellwood M · Texarkana, TXBuilt 1964 · S/N 17252265N8366GRovers Adrian J · Chazy, NYBuilt 1965 · S/N 15062466N8366JRobertson R Topp · Decatur, TXBuilt 1967 · S/N 15066266N8366LCurwin Randy S · Villa Rica, GABuilt 1968 · S/N 17256566N8366MMccauley Aviation Inc · Springfield, TNBuilt 1969 · S/N A15000066N8366UHob Aero Inc · Freeland, MIBuilt 1964 · S/N 17252266N8367GRangesh Abinand · Newton, MABuilt 1965 · S/N 15062467N8367LRay Allens Electronics Inc · Butler, GABuilt 1968 · S/N 17256567N8367MConner Jacob P · Kaplan, LABuilt 1969 · S/N A1500067N8367UTb Maintenance And Cleaning LLC · Deltona, FLBuilt 1964 · S/N 17252267N8367ZMccole Kevin · Brookline, NHBuilt 1963 · S/N 205-0367N8368GClark Jeffrey S · Knoxville, TNBuilt 1965 · S/N 15062468N8368JVickers Lindsay · Fuquay Varina, NCBuilt 1967 · S/N 15066268N8368LMeltzair LLC · Fryeburg, MEBuilt 1968 · S/N 17256568N8368SKangas Gary J · Fairbanks, AKBuilt 1965 · S/N 18256468N8369JDtm Enterprises Inc · Bronson, MIBuilt 1967 · S/N 15066269N8369LInternational Air Services Inc Trustee · Carson City, NVBuilt 1968 · S/N 17256569N8369UCamden Aviation LLC · Lewes, DEBuilt 1964 · S/N 17252269N836DBR&L Sales LLC · North Vernon, INBuilt 1969 · S/N 17701366N8370GCarter Edward D · Ethel, MOBuilt 1965 · S/N 15062470N8370JBrown David A · Lumberton, TXBuilt 1967 · S/N 15066270N8370MLandry Paul G · Fallon, NVS/N A1500070N8370SBerti Robert Cord · Wilton, CABuilt 1965 · S/N 18256470N8370USimonsen Joshua A · White Salmon, WABuilt 1964 · S/N 17252270N8371MNosewheels Navy LLC · Rochester Hills, MIBuilt 1969 · S/N A1500071N8371SLamm Matthew S · Morristown, NJS/N 18256471N8372JPaquette Michael J · Greene, NYBuilt 1967 · S/N 15066272
Back to AD 72-03-03 R3