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.

N2638XSoftware 2000 Inc · Arroyo Grande, CABuilt 1979 · S/N 310R1666N2638ZHowlett Corey W · Wasilla, AKBuilt 1963 · S/N 185-0638N26390Rucker Roger D · Pembroke Pines, FLBuilt 1978 · S/N AA5A0557N26396Vergona John T · Canton, MIBuilt 1978 · S/N AA5A0561N26398Fenton David W · Kihei, HIBuilt 1978 · S/N AA5A0562N2639CClear And Seven LLC · Santa Teresa, NMBuilt 1978 · S/N R18200189N2639FHendershott Kevin J · Vacaville, CABuilt 1965 · S/N 18256739N2639GHusted Dean T · Hicksville, OHBuilt 1959 · S/N 51934N2639WBrown Jeffrey R · Leesburg, FLBuilt 1966 · S/N 976N263AAWilkey Michael B · Kingston, GABuilt 1958 · S/N D-5581N263ATAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 2001 · S/N 4496087N263BPederstuen Ricky L · Hudson, WIBuilt 1957 · S/N 23N263BCChambers William M · Elkmont, ALBuilt 2005 · S/N 9058N263BEEngen Burdell M · Viking, MNS/N 263N263DWWarren David T · Mobile, ALBuilt 1959 · S/N 51970N263EAJdcwac LLC · Blair, NEBuilt 2002 · S/N E-3437N263EPEpic Aviation Inc · Denison, TXBuilt 2026 · S/N 172S13503N263MAMacair Aviation LLC · Xenia, OHBuilt 2004 · S/N 968-2004N263MGGeorgia Aviation Authority · Eastman, GABuilt 2020 · S/N 2881361N263NDPlane Nonsense Inc · Middletown, DEBuilt 1999 · S/N 2842064N263SAColumbia Asset Trust Corp Trustee · Wichita, KSBuilt 1999 · S/N E-3283N263SFAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 172S13406N263WYMarshall Laird Jr · Kemmerer, WYBuilt 2016 · S/N 3263N26401Mann James R · Waikoloa, HIBuilt 1978 · S/N AA5A0565N26406Registration Pending · Valdosta, GARegistration pendingBuilt 1978 · S/N AA5A0568N26407Colvin Daniel A · Dayton, TNBuilt 1978 · S/N AA5A0569N2640FLaguna Verde Leasing Inc · Wilmington, DEFirst renewal noticeBuilt 1979 · S/N 310R1676N2640MStraight Gary D · Wasilla, AKBuilt 1946 · S/N 12-982N2640PCrumley Emily M · Bristol, TNBuilt 1955 · S/N 22-2978N2640YMarc Aircraft Holding LLC · Soldotna, AKBuilt 1962 · S/N 18051140N26410Villanueva Francisco B · Leavenworth, KSBuilt 1978 · S/N AA5A0570N26411Cheetah LLC · Burlington, IABuilt 1978 · S/N AA5A0571N26412Pelican Fisheries Corp · Mount Pleasant, SCBuilt 1977 · S/N AA5A0493N26414Ambrose Douglas · Indio, CABuilt 1978 · S/N AA5A0578N26415Khano Maurice S · Kennesaw, GABuilt 1978 · S/N AA5A0579N2641PChandler David G · Phoenix, AZBuilt 1979 · S/N 310R1679N2641RHowatt Scott · Hannah, NDBuilt 1967 · S/N 18258341N2641WRampini Daniel G · Cleveland, OHBuilt 1966 · S/N 3303N2641ZTfs Air LLC · Loveland, COBuilt 1979 · S/N 310R1804N26422Cressey Aaron · Silverton, ORBuilt 1978 · S/N AA5A0582N26423Poulnott William · Milledgeville, GABuilt 1978 · S/N AA5A0583N26424Ormanian Austin · Canton, MIBuilt 1978 · S/N AA5A0584N26427She Runs I Fly LLC · Cincinnati, OHBuilt 1978 · S/N AA5A0585N2642ACronin LLC · Jacksonville, FLBuilt 1979 · S/N 310R1682N2642CMuniz Elmer · Port Saint Lucie, FLS/N 35042N2642DBurchard Farms LLC · Melber, KYBuilt 1988 · S/N 0820N2642GWillis Andrew B · Wasilla, AKBuilt 1959 · S/N 51942N2642MLons Travis W · King Salmon, AKBuilt 1946 · S/N 12-984N2642QLongerbone Danny L · Fishers, INBuilt 1970 · S/N 17258931N2642SReich Stephen Barry · Kentfield, CABuilt 1976 · S/N 21061345
Back to AD 2007-04-19 R1