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.

N46418Batesquire LLC · Clanton, ALS/N 17257254N46419Rodgers Bruce W · Ramona, CABuilt 1968 · S/N 17257255N4641BKey James M · Hermiston, ORBuilt 1955 · S/N 31539N4641JN4641j LLC · Mulberry, FLBuilt 1968 · S/N 28R-30531N4641QFitzsimons Nicholas T · Covington, LABuilt 1973 · S/N 17261733N4641RWebb Patrick S · Chuckey, TNBuilt 1966 · S/N 28-21394N46420Frontier Environmental Solutions Inc · Inyokern, CAS/N 17257256N46423Parrish Aviation Flight Academy LLC · Southlake, TXS/N 17257259N4642BRegister Edmond A · Tyler, TXBuilt 1955 · S/N 31540N4642PColumbus Sign Co · Columbus, GAS/N 27-163N4642RSkyways Group LLC · Greensboro, NCBuilt 1966 · S/N 28-21396N4642UHolt John William · Tucson, AZFirst renewal noticeBuilt 1964 · S/N 18051342N4642VBolster William L · Joshua Tree, CABuilt 1978 · S/N VAC-96-78N4642WHash Marshall W · Crumpler, NCS/N 13172N4642YFriends Aviation Inc · Wilmington, DEBuilt 1967 · S/N 25-4361N46430J & Dk LLC · Overland Park, KSBuilt 1968 · S/N 17257263N46433Plummer Fred C · Normal, ILBuilt 1968 · S/N 17257264N46435Hawkins County Sports Wings Inc · Kingsport, TNBuilt 1968 · S/N 17257266N46436Aero Science International LLC · Martinez, GABuilt 1968 · S/N 17257267N46437Arizona Active Air LLC · Yuma, AZBuilt 1968 · S/N 17257268N4643BAnderson Charles D · Fairbanks, AKBuilt 1955 · S/N 31541N46440Engelskirger Karl D · Valley City, OHS/N 17257270N46442Lott Terence D · Florence, MSBuilt 1968 · S/N 17257272N46448Mac Air Inc · Farmington, MOBuilt 1968 · S/N 17257276N46449Tilma Flying Club Inc · Moscow, IDBuilt 1968 · S/N 17257277N4644ALee Lauren M · West Greenwich, RIBuilt 1956 · S/N 32241N4644CMassmanf Darrel F · Ogdensburg, WIBuilt 1974 · S/N 18502585N4644FBrennan Timothy R Trustee · Mount Pleasant, SCBuilt 1966 · S/N P206-0244N4644JWinslow Francis E III · Raleigh, NCS/N 17273659N4644PFennema Alan A · San Jose, CABuilt 1960 · S/N 27-165N4644UWineglass Holdings LLC · Fort Davis, TXBuilt 1983 · S/N 21064797N4644VHendricks Trenton Q · Bow, WABuilt 1978 · S/N VAC-98-78N4644YState Of Montana · Helena, MTBuilt 1971 · S/N 18-8945N46457Ostrowski Sven E · Mullica Hill, NJS/N 17257281N4645BJacobs Lydia A · Lincoln, MES/N 31543N4645JHitchcock Scott B · Waco, TXBuilt 1968 · S/N 28R-30538N4645KOrange Air Inc · Harbor City, CANon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 18263647N4645RKunz Consulting Inc · Sun Prairie, WIBuilt 1966 · S/N 28-21399N4645WClimb Maintain LLC · Morrisville, MOBuilt 1977 · S/N 13175N4646Bailey Christopher J · Riga, MIBuilt 1975 · S/N M-II-480N46460Walter Timothy G · Farmersburg, IABuilt 1968 · S/N 17257283N46462Cook Aviation Services LLC · Fargo, NDBuilt 1968 · S/N 17257285N4646ANorth Sixty Taildraggers LLC · Port Ludlow, WABuilt 1956 · S/N 32243N4646BBravo 300 LLC · Coweta, OKS/N 31544N4646CWilliam Michael Moody · Anchorage, AKBuilt 1975 · S/N 18502586N4646HMilton Djana · Lakewood, WABuilt 1981 · S/N 18267847N4646JCulley Johnny C · Amarillo, TXBuilt 1968 · S/N 28R-30539N4646KPloense Justin M · Big Bear City, CAS/N 18263648N4646RWarren Global LLC · Chino, CABuilt 1966 · S/N 28-21400N4646VBaran Stephen · Littlestown, PABuilt 1978 · S/N VAC-100-78
Back to AD 2007-04-19 R1