OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,139

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

N8844JCave Anthony B · Round Rock, TXBuilt 1965 · S/N 28-2802N8844NBruegmann Fred R III · Northfield, ILBuilt 1969 · S/N 28-25695N8845JWilliams Daniel · Wallingford, KYBuilt 1965 · S/N 28-2803N8846JFighter Pilot Enterprises LLC · Eaton, COBuilt 1965 · S/N 28-2804N8846NDegener William L · Leonard, TXBuilt 1969 · S/N 28-25697N8847FNeitzer Robert W · Milwaukee, WIBuilt 1976 · S/N 28-7725126N8847JFlw LLC · Sandpoint, IDS/N 28-2805N8847NMcdougal Thomas K · Woodward, OKBuilt 1969 · S/N 28-25699N8848JMegaw George C · Fort Lauderdale, FLBuilt 1965 · S/N 28-2806N8848NPro Tech Aviation LLC · Corona, CABuilt 1969 · S/N 28-25700N8849JBailey Aviation Company LLC · Little Rock, ARBuilt 1965 · S/N 28-2807N8849NCafran Lloyd V · Youngsville, NCBuilt 1969 · S/N 28-25701N8850NGregs Airplane Rental LLC · Eloy, AZBuilt 1969 · S/N 28-25702N8851JMoore Jeffrey A · Lawrenceburg, TNBuilt 1965 · S/N 28-2815N8851NBloodworth Nathan B · Hendersonville, TNS/N 28-25703N8853JN8853j LLC · Oak Park, ILBuilt 1965 · S/N 28-2817N8853NN8853n LLC · Poplar Bluff, MOS/N 28-25707N8855NIndy Distributors Inc · Noblesville, INBuilt 1969 · S/N 28-25709N8856JFifty Six Juliet LLC · West Lafayette, INS/N 28-2820N8856NGrant Shane J · Cape Coral, FLBuilt 1969 · S/N 28-25711N8857JNguyen Tu K · Costa Mesa, CABuilt 1965 · S/N 28-2822N8857NWolf Terry T · Lake Katrine, NYBuilt 1969 · S/N 28-25712N8858JBirdie N88 LLC · Conifer, COBuilt 1965 · S/N 28-2928N8859NThrash Enterprises LLC · Clarksville, TNBuilt 1969 · S/N 28-5340N8860JBjg LLC · Langdon, NHBuilt 1965 · S/N 28-2826N8861NMcdonald Timothy A · Rush City, MNBuilt 1969 · S/N 28-25410N8862NHatley Wayne S · Hermitage, TNBuilt 1969 · S/N 28-25717N8864NKnutson Wayne R · Thompson, NDS/N 28-25725N8866NYu Hermon Lemuel C · Mays Landing, NJBuilt 1969 · S/N 28-26251N8866YCarson Ryan P · Albuquerque, NMBuilt 1971 · S/N 28-7125339N8867NMulloy Dennis · Indian Mound, TNBuilt 1969 · S/N 28-25729N8868JGannon Robert M · Hamburg, NYBuilt 1968 · S/N 28-24354N8869JRoot Roger T · Moscow, IDBuilt 1965 · S/N 28-2841N8869NCarland Ralph B · Altoona, PABuilt 1969 · S/N 28-25731N8870JAsel LLC · North Charleston, SCS/N 28-2842N8870NRiley Dennis M · Surry, MEBuilt 1969 · S/N 28-25732N8871JJohnson Richard E · Mulberry, FLBuilt 1965 · S/N 28-2843N8871NCramer Michael L · Rockville Centre, NYBuilt 1969 · S/N 28-25733N8872JPriority Aviation LLC · Lewes, DES/N 28-2844N8874CPleasant Valley Aviation Inc · Bellefonte, PABuilt 1976 · S/N 28-7625135N8874JMelland Curtis B · Hazen, NDBuilt 1965 · S/N 28-2847N8874NFisher Tim A · Stockton, MDBuilt 1969 · S/N 28-25737N8875NMcclendon Charles Dowel · Lynchburg, VABuilt 1969 · S/N 28-25738N8876JDestination Flyer LLC · Memphis, TNBuilt 1965 · S/N 28-2848N8877EParrot Flying LLC · San Francisco, CABuilt 1976 · S/N 28-7625162N8878NCampbell Carl F · Amherst, NHBuilt 1969 · S/N 28-25741N8879EFlickinger Charles P · Hermitage, PAS/N 28-7625163N8879JDaddona John M · Oakville, CTBuilt 1965 · S/N 28-2852N8879NBesheer Susan Anita · Palm Springs, CABuilt 1969 · S/N 28-25743N8880NAnderson Aviation LLC · Bulverde, TXS/N 28-25744
Back to AD 96-10-01 R1