OpenAirDocs.org
AD 2007-04-19 R1

Registered aircraft · 108,433

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:2007-04-19-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:2007-04-19-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.

N2504BHatz Aeronautics LLC · Pompano Beach, FLBuilt 1989 · S/N 862N2504RJht Aviation LLC · Longview, TXBuilt 1967 · S/N 18258204N2504WBade Russell E · Carlsbad, CAS/N 22839N2504XInspire Technologies Inc · Caldwell, IDBuilt 1964 · S/N P206-0004N25055Dakota N25055 LLC · Irvine, CABuilt 1985 · S/N 28-8511018N25059West William Douglas · Newton, NCS/N 936N2505FAcme Anvil LLC · Parker, COBuilt 1965 · S/N 127N2505RTcheutchua Romeo J · Olathe, KSBuilt 1969 · S/N 28-5638N2505XGaviaire Aviation LLC · El Reno, OKBuilt 1965 · S/N P206-0005N2505ZStratton Robert Stephen · Boulder, COFirst renewal noticeBuilt 1977 · S/N 330-77N2506QJohnson Jason D · Doniphan, MOBuilt 1966 · S/N 18257706N2506TTango LLC · Anchorage, AKS/N NAV-4-2506N2506WHeiss William R · Watkins, COS/N MC-165N2506XBaumberger Gene C · Greenville, ILBuilt 1965 · S/N P206-0006N2506ZKisser Karl J · Anchorage, AKBuilt 1977 · S/N 614-77N2507Wagar Dennis Murphy · Marion, MTBuilt 2022 · S/N 5330N2507GBanks Gary M Jr Trustee · Scituate, MABuilt 1959 · S/N 51807N2507JDarter Lloyd R · Mountain Grove, MOBuilt 1979 · S/N T18803469TN2507KLabonte Stephen M · Gilford, NHBuilt 1968 · S/N 217N2507RKandle Sherry A · Boise, IDBuilt 1967 · S/N 18258207N2507TCoscarelli Guillrtmo H · Wailuku, HIS/N 914N2507WHoffman Ray Y · Elysburg, PARegistration revokedBuilt 1973 · S/N MC-190N2507ZZawada John R · Wht Sphr Spgs, MTBuilt 1999 · S/N 55N2508GBig Well Flying Club Inc · Kinsley, KSBuilt 1959 · S/N 51808N2508RBrodt Gregory L · Chetek, WIBuilt 1967 · S/N 18258208N2508SErnst Don A · San Luis Obispo, CABuilt 1976 · S/N 21061311N2508WBas Part Sales LLC · Greeley, COS/N MC-166N2508XCaspaar Valentin · Seattle, WABuilt 1965 · S/N P206-0008N25096Green Air LLC · Novato, CAS/N 961N2509DLong Joel A · Clinton, MOBuilt 2000 · S/N 22501N2509KHolcomb John R · Siloam Springs, ARBuilt 1978 · S/N 18052962N2509PAubort Eric Y · Laguna Hills, CABuilt 1955 · S/N 22-2870N2509RStovall Shane R · Salado, TXBuilt 1969 · S/N 28-5639N2509TFarah Gregory · Meredith, NHBuilt 1968 · S/N NAV-4-2509N2509XOrsippus Management LLC · El Dorado Hills, CAS/N 951N2509ZKovach Kim A · Ocala, FLS/N 333-77N250AUPeregrine Howard Partners II Lp · New Orleans, LABuilt 2024 · S/N 172S13265N250BASouthern Cub & Aircraft Restoration LLC · Pensacola, FLBuilt 1971 · S/N 25-5425N250BDSalom Auguste G · Old Orchard Beach, MEBuilt 1965 · S/N 27-3082N250CCAerodynamics Worldwide Inc · Wilmington, DEBuilt 1960 · S/N 24-1931N250CHSorrell Jeffrey R · Winter Haven, FLS/N 250N250CRTruflight Leasing LLC · Owasso, OKBuilt 2023 · S/N 1336N250CW250 Charlie Whiskey LLC · Topeka, KSBuilt 1982 · S/N 18268273N250DCHightower George Jr · Thomaston, GABuilt 1979 · S/N TK-91N250DJRhoades James H · Pleasanton, CABuilt 1980 · S/N 0003-80N250DSLanger Paul Hubert · Gainesville, TXBuilt 1996 · S/N 250N250ESilver Creek Aviation Services · Fort Worth, TXBuilt 2005 · S/N 20608250N250EWPlane Fun Inc Tr Trustee · Snellville, GABuilt 2020 · S/N 18283106N250FBishop Thomas W · Decatur, TXBuilt 1959 · S/N 52184N250FDTailwind Aviation Inc · Sault Sainte Marie, MIBuilt 1976 · S/N 27-7654148
Back to AD 2007-04-19 R1