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.

N30579Dry Creek Services LLC · Lodi, OHBuilt 1974 · S/N 17264145N3057CClb LLC · Lewes, DEFirst renewal noticeS/N D-5713N3057FN3057f LLC · Branson, MOBuilt 1978 · S/N 28-7990226N3057MAg Aero Inc · Lenzburg, ILBuilt 1977 · S/N 28-7890293N3057PMcneil Michael D · Caro, MIS/N 23-969N3057QJoseph C Casey · Lufkin, TXS/N 18258057N3057WBaskins Robert H · Huntington Beach, CABuilt 1973 · S/N D-9557N3057YJjm Aviation LLC · Newport, NCBuilt 1962 · S/N 18254057N30583Roviaro Edward · Schererville, INBuilt 1973 · S/N 21059936N30584New Horizons Aviation LLC · East Helena, MTBuilt 1969 · S/N 17701344N3058ROn Top Aviation LLC · Salinas, CABuilt 1998 · S/N TH-1870N3058TN3058t LLC · Cheyenne, WYBuilt 1979 · S/N 28R-7918062N3058VN5237l LLC · Oswego, NYS/N 1617N3058ZLove Glen L · Poplar Grove, ILBuilt 1959 · S/N 22-7013N30592Kussmaul Richard · Clinton, MIBuilt 1994 · S/N 11093CN30593Valiair Lc Trustee · Casper, WYBuilt 1973 · S/N 21059938N30597Brewer Aviation LLC · Winslow, ARBuilt 1969 · S/N 17701350N30599Wilson Phillip W Jr · Kailua, HIBuilt 1969 · S/N 17701351N3059BBay De Noc Flying Club Inc · Escanaba, MIBuilt 1978 · S/N 28-7990138N3059CFellows David O · Mc Alpin, FLBuilt 1958 · S/N D-5715N3059FAtwell Charles A · Eldred, NYBuilt 1969 · S/N 28-25760N3059GStulp Annessa C · Lamar, COBuilt 1968 · S/N 37N3059RTimes Arrow LLC · Highland, MDBuilt 1969 · S/N 28R-35620N3059SRatte Clifford H · Gulf Breeze, FLBuilt 1979 · S/N 28R-7918061N305APhiladelphia Glider Council Inc · Hilltown, PABuilt 1951 · S/N 23182N305ABL-19 Birddog LLC · Huntington, INBuilt 1951 · S/N 21290N305ADScreaming Rubber Chicken Aviation LLC · Boise, IDS/N 21783N305AFPlaskon Kate Trustee · San Rafael, CABuilt 1999 · S/N 305AFN305APDoc Joey Inc · Wilmington, DES/N 0500N305BCProp & Wing Aviation Inc · Humble, TXBuilt 1982 · S/N CE-993N305BJJones Marvin B · Farmerville, LABuilt 1951 · S/N 22465N305BSAllen Andra L · Gila, NMBuilt 1999 · S/N S1796N305CABrinker Joe E Jr · Little Hocking, OHBuilt 1964 · S/N TC-584N305CMLegacy Flight Museum · Rexburg, IDBuilt 1957 · S/N 24558N305CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11532N305CRSeewald Jeffrey W · Great Bend, KSBuilt 1950 · S/N 21483N305DFPrecision Delta Corp · Ruleville, MSBuilt 1950 · S/N 21163N305DKWashington State Patrol · Olympia, WABuilt 1999 · S/N 20608080N305EPPickard Erik · Deer Park, TXBuilt 1982 · S/N 25-0656N305FStockdale Aviation LLC · Crawford, COBuilt 1963 · S/N 18254903N305FUDustoff LLC · Concord, NHBuilt 1951 · S/N 21741N305HPDlc Sky LLC · North Miami, FLS/N E-3852N305JPPattison Jeffrey L · Glasgow, MTBuilt 1951 · S/N 21789N305JRHarrison Aviation LLC · Salem, ORBuilt 2005 · S/N 18281692N305JTWinniwolfe Holdings LLC · Wolfeboro, NHBuilt 1986 · S/N 25-1075N305KGBelisle Kenneth C · Jacksonville, FLS/N SN038N305KTAlvord Jonathan Drew · Prosser, WABuilt 2010 · S/N 40064N305KWPumpkin Eater LLC · Tavares, FLBuilt 1978 · S/N U20604213N305LWProfessional Flyers Corp · Wilmington, DEBuilt 1980 · S/N 25-0388N305MHartley John · Kissimmee, FLBuilt 1987 · S/N 25-1140
Back to AD 2007-04-19 R1