OpenAirDocs.org
AD 72-03-03 R3

Registered aircraft · 17,025

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.

N1566HRohlfing Gregory C · Elmwood Park, ILBuilt 1975 · S/N 177RG0740N1566QMexico Missions & Beyond Inc · Harrison, TNS/N 15072866N1567HKrimminger Michiel · Lancaster, SCBuilt 1975 · S/N 177RG0741N1568HCorner Jeremy M · Peachtree City, GABuilt 1975 · S/N 177RG0742N1569HDekalb Cardinal LLC · Evanston, ILBuilt 1975 · S/N 177RG0743N156AEHolt Cory J · Santa Ynez, CABuilt 1962 · S/N 18254549N156KAXclusive Level Auto Glass LLC · Kissimmee, FLBuilt 1973 · S/N 15074980N1570QColvin William E · Newberry, FLBuilt 1971 · S/N 15072870N1570UReno70 LLC · Anchorage, AKBuilt 1970 · S/N 20700170N1571HYork Ronald A · West Lafayette, INBuilt 1975 · S/N 177RG0745N1572QStenberg Andrea Renee · Edmonds, WAS/N 15072872N1573QFergeson Matthew C · Dwg, TXBuilt 1971 · S/N 15072873N1574LNghiem Daniel · Westminster, CABuilt 1973 · S/N A1500460N1575HCardinal Shares Inc · Rochester, MNS/N 177RG0749N1575QKelley Jack T Jr · Linden, NCS/N 15072875N1578HKramer Jason K · Longview, TXBuilt 1975 · S/N 177RG0752N1578QBrown Carolyn J · West Ossipee, NHBuilt 1971 · S/N 15072878N1579QChastain Elizabeth A · Saint Louis, MOBuilt 1971 · S/N 15072879N157DF157df LLC · Madison, WIS/N 17260646N157KAPhillips David Jj · Orlando, FLS/N 15075210N1580HBrock Bobby Charles · New Braunfels, TXBuilt 1975 · S/N 177RG0754N1581HNevarrow Leon · Spring Valley, CAS/N 177RG0755N1582HT G & P Enterprises LLC · Glendale, AZBuilt 1978 · S/N 177RG1364N1587HFowler James C · San Angelo, TXBuilt 1975 · S/N 177RG0761N1587UGrant Aviation Inc · Anchorage, AKS/N 20700187N1589HAg Scouting Solutions LLC · Huntingdon, TNBuilt 1975 · S/N 177RG0763N158PMLowrey Jonathan S · Jasper, INBuilt 1971 · S/N 17260064N1590HWieting Roger L · Longview, TXBuilt 1975 · S/N 177RG0764N1590QHeyde Raymond E · Hernando, FLBuilt 1971 · S/N 15072890N1591QBas Part Sales LLC · Greeley, COBuilt 1971 · S/N 15072891N1592QProietto Nicholas Philip · West Grove, PABuilt 1971 · S/N 15072892N1593HKleinert John K · Baldwin, GABuilt 1975 · S/N 177RG0767N1594QLesniak Myra D · Hillman, MNS/N 15072894N1595HSholy Fred · Granada Hills, CAS/N 177RG0769N1597HAerobox LLC · Seattle, WABuilt 1975 · S/N 177RG0771N1599QGonzalez Anthony H · Rancho Cordova, CABuilt 1971 · S/N 15072899N159RJBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 17702038N15CSBartlett Branden S · Chugiak, AKBuilt 1974 · S/N R172-GC-3N15GWFlight Brothers LLC · Sachse, TXBuilt 1969 · S/N 17258161N15NFRegistered aircraftBuilt 1969 · S/N 17258204N15RAAviation Career Enrichment Inc · Atlanta, GABuilt 1970 · S/N 17259568N15SRAllen Rodney · Connellsville, PABuilt 1971 · S/N 15073055N15SWNi Oliver Xingyuan · Norfolk, VABuilt 1968 · S/N 17256875N15WGSwirk Rhonda L · Center Conway, NHBuilt 1968 · S/N 18259444N16003Coats Jeff · Twin Falls, IDBuilt 1972 · S/N 15073402N16006Lazor Ron E · Middlefield, CTBuilt 1972 · S/N 15073405N16007Cottrell Alan L · Toano, VAS/N 15073406N16011Dennis Ronnie Lee · Odessa, FLBuilt 1972 · S/N 15073409N16012Filasky Joseph J · Aquebogue, NYBuilt 1972 · S/N 15073410N16015Rodriguez Richard · Indianapolis, INS/N 15073413
Back to AD 72-03-03 R3