AD 2007-04-19 R1

Registered aircraft · 108,434

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.

N4951YH & B Aeronautics LLC · Miamisburg, OHBuilt 1980 · S/N 21064057N4952EHess Michael D · Wasilla, AKBuilt 1979 · S/N 18503918N4952GHighland Rim Aviation LLC · Springfield, TNS/N 17273499N4952LWalters Larry C · Wasilla, AKS/N 28-4323N4952SPrecision Delta Corp · Ruleville, MSBuilt 2010 · S/N 1458-2010N4952TKeith Investments LLC · Verona, MSS/N R18201802N4953AOlson Andrew P · Garfield, WABuilt 1956 · S/N 32350N4953EInland Fisheries And Wildlife · Augusta, MEBuilt 1979 · S/N 18503919N4953FQuinney William B · Kill Devil Hills, NCS/N 28-7725037N4953GMcfly LLC · Casper, WYBuilt 1979 · S/N 17273500N4953JLent Kevin C · Glenwood, MNBuilt 1968 · S/N 28R-30699N4953LSale Reported · Harrells, NCSale reportedBuilt 1967 · S/N 28-4324N4953VMccreery Aviation Co Inc · Mcallen, TXBuilt 1980 · S/N 172RG0423N4954DTracy Scott J · Santa Barbara, CAFirst renewal noticeBuilt 1958 · S/N 51054N4954FGq Aviation LLC · Cherry Hill, NJBuilt 1976 · S/N 28-7715086N4954GKris Noone Air LLC · Wilmington, DEBuilt 1979 · S/N 17273501N4954LSavoie John P · Jal, NMBuilt 1967 · S/N 28-4325N4955DBerman David M · Charlotte, NCBuilt 1979 · S/N 17272409N4955LDakan John M · Hemet, CABuilt 1967 · S/N 28-4326N4955PJuber Glenn E · Coconut Creek, FLBuilt 1963 · S/N 27-555N4955YLancaster Bryant F Jr · Troutman, NCBuilt 1980 · S/N 21064058N4956DSorbi Aviation Inc · El Cajon, CABuilt 1979 · S/N 17272410N4956MMurray Timothy · Orlando, FLBuilt 1978 · S/N CE-781N4956NCosta Luiz A · Fort Myers, FLBuilt 1980 · S/N 18267480N4956VRegistered aircraftBuilt 1980 · S/N 172RG0425N4957DCummings Roy E · Fort Scott, KSBuilt 1958 · S/N 51057N4957EKuckkahn Dale P · Lake Tomahawk, WIS/N 22-4222N4957FBravo Hotel LLC · Lewes, DEBuilt 1966 · S/N U206-0657N4957LButler Cole A · Snowflake, AZBuilt 1967 · S/N 28-4328N4957NRegistered aircraftS/N 18267481N4957ZGuinasso Kimberly Marsh · Reno, NVS/N U20606059N4958DHarmon Jon E · Turner, MTBuilt 1958 · S/N 51058N4958FJuoni Joshua Charles · Oklahoma City, OKBuilt 1976 · S/N 28-7790078N4958JWinfrey Justin R · San Francisco, CAS/N 28R-30706N4958LOgren James A · De Smet, SDBuilt 1968 · S/N 28-5007N4958QSnider Scott E DBA · Turner, MTBuilt 1976 · S/N 18802692TN4958VFrank John M Jr · Alexandria, VABuilt 1980 · S/N 172RG0427N4959CDoll House Properties Inc · Chesapeake, VABuilt 1979 · S/N 21063689N4959DEdwards Stephen L Trustee · Wasilla, AKBuilt 1959 · S/N 50511N4959JTaylor James O · Marengo, ILS/N 28R-30708N4959LFly Cht LLC · Chillicothe, MOBuilt 1967 · S/N 28-4330N4959SStrickland Luther Jearl · San Luis Obispo, CABuilt 2010 · S/N 40214N4959VCutlass Cruisers Inc · Howard Lake, MNBuilt 1980 · S/N 172RG0428N4959WSteverson Jill T · Newhebron, MSBuilt 1977 · S/N 14279N495ABRayburn Jason A · Gibbon, NEBuilt 2008 · S/N 22638N495ACRegistration Pending · Honolulu, HIRegistration pendingBuilt 1999 · S/N 1265-99N495AUCohen Aircraft Leasing & Sales LLC · Dunwoody, GABuilt 2010 · S/N TH-2287N495BFFlood Bryan P · Minneapolis, MNBuilt 2021 · S/N 40497N495CSmith David W · Milaca, MNS/N 259N495CDJl Aviation LLC · Crestwood, KYBuilt 2005 · S/N 1605
Back to AD 2007-04-19 R1