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.

N22AQSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1993 · S/N 2316MN22AYRegistration Pending · Lebanon, PARegistration pendingBuilt 2004 · S/N 1176N22AZMeyer Damon G · Saco, MEBuilt 1993 · S/N 442N22BAKovalchuk Richard W · Rosharon, TXBuilt 1976 · S/N AA5A0238N22BCSky Shark Aviation LLC · Brandon, MSBuilt 1975 · S/N 535-75N22BMButler Francis J · Fargo, NDBuilt 2003 · S/N 80471N22BSSmith Aviation Inc · Wilmington, DEBuilt 1976 · S/N TC-1928N22BUBruner Charles P Jr · Calabasas, CABuilt 1987 · S/N BRUNER 0001N22BYDelton LLC · Pembroke Pines, FLBuilt 1964 · S/N D-7609N22CRegistered aircraftBuilt 1958 · S/N 51007N22CBVollstedt Gregory Scott · Anchorage, AKBuilt 1973 · S/N 185-02188N22CCLegacy Air LLC · Oklahoma City, OKBuilt 1984 · S/N TJ-471N22CFGame Equipment Services LLC · Midland, TXBuilt 1961 · S/N 18253217N22CJCleveland Adam · Abilene, TXBuilt 1965 · S/N 30-905N22CVMcginley Donald J · Port Orange, FLBuilt 1973 · S/N 21059974N22DBSalisbury Mark J · Green Cove Springs, FLBuilt 2002 · S/N 0205N22DDLoegering Daniel P · West Fargo, NDS/N 1650N22DECrawford Edgar A · Locust Grove, GABuilt 1970 · S/N 17259168N22DQ2 Wings LLC · Noblesville, INS/N DFQ-1N22DRScott Aero LLC · Hudson Oaks, TXS/N 73-30596N22DSSwartwout David C · Sedona, AZBuilt 1961 · S/N CD-446N22DVSamoilenko Nadia S · Hillsborough, NCS/N 28-1763N22DXHawk Daniel G · Cocoa, FLBuilt 1958 · S/N 51442N22ECDoose Christopher A · Memphis, TNBuilt 1973 · S/N 310Q0732N22EDGrant Douglas R · Foster City, CAFirst renewal noticeBuilt 1954 · S/N D-3820N22EEMullen James J · Estero, FLBuilt 1981 · S/N 62P09228165046N22EPRobinson Michael · Tucson, AZBuilt 1972 · S/N 21059773N22EVMeggers Roger D · Baker, MTBuilt 1989 · S/N 1809022N22EWHoltaway Robert F · Bullock, NCBuilt 1968 · S/N TC-1058N22EXIntriago Elisa M · Miami, FLS/N 07N22FARosen Barry W · West Hollywood, CABuilt 2003 · S/N 0782N22FBWilson Travis · Beaver Dam, KYS/N 21060634N22FGState Of California Department Of Fish And Game · Sacramento, CABuilt 1983 · S/N 18504407N22FHPapasavas Paul A · West Orange, NJBuilt 1965 · S/N 783N22GBHolland Kenneth F Trustee · Santa Clarita, CABuilt 1977 · S/N 310R1237N22GCSkydive Ky LLC · Cecilia, KYBuilt 1953 · S/N 30532N22GDMagafly LLC · Bay City, MIBuilt 1964 · S/N CD-783N22GHCorbusier James J · Monkton, MDBuilt 2005 · S/N E-3640N22GJTaffet Jay · New Orleans, LAS/N 32-8006026N22GLMancini Joseph · Baltimore, MDBuilt 1978 · S/N GL-1N22GNSkattum LLC · Sioux Falls, SDBuilt 1956 · S/N 22-3948N22GPDunkelburg David L · Milton Freewater, ORBuilt 1963 · S/N 58202N22GXKiser Raymond Paul · Sebring, FLBuilt 2004 · S/N 0980N22HABig Bend Aviation LLC · Odessa, TXBuilt 1979 · S/N 28R-7918053N22HBHubele Conrad · Tucson, AZS/N 310G-0046N22HCHarcourt David R · Alabaster, ALS/N HC-2N22HGFreeno Joseph · Upland, CAS/N CE-1102N22HTTobler Hans P · Anchorage, AKS/N 1858N22HUGove Gary Alan · Marion, MTS/N 1355N22JBJones Robert Y · Alba, TXBuilt 1975 · S/N 427
Back to AD 2007-04-19 R1