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.

N467ERWingsleasing LLC · Wichita, KSS/N 172S10287N467FAMain Line Flight School LLC · Haverford, PABuilt 2022 · S/N 28020067N467GRRoach Gene T · Frankfort, KYS/N 892N467HABuell Travis · Harper, TXBuilt 2001 · S/N 0984N467PEOkane James K · Noblesville, INBuilt 2013 · S/N 1N467PZAirline Training Professionals LLC · Wilmington, DEBuilt 1980 · S/N P21000475N467QStegner John J · Boonville, MOBuilt 1976 · S/N 17266649N467TWiley Barbara · Yellow Springs, OHBuilt 1960 · S/N TC-39N467TFHarts Joel D · Coffeyville, KSBuilt 1995 · S/N 1N467TSPsl Surveys · Manassas, VABuilt 2010 · S/N 18282239N468Downs Daniel D · Phoenix, AZBuilt 1982 · S/N 7417CN4680DSmith Larry D · Friendswood, TXBuilt 1957 · S/N D-4889N4680JCorral Oscar L · Ft Stockton, TXS/N 350N4680KIntrepid Red Baron Inc · New Franken, WIBuilt 1975 · S/N 18263681N4680NRentz Communications Inc · New Smyrna Beach, FLBuilt 1978 · S/N 414A0070N4680PSchmidt Aaron B · Auburn, ALBuilt 1983 · S/N P21000814N4680RGibbs Robert I · Ravenswood, WVBuilt 1966 · S/N 28-21439N4680UFoster Randy · La Grange, TXBuilt 1964 · S/N 18051380N4681FFisher Adam · Corona, CABuilt 1966 · S/N P206-0281N4681JRose Jeffrey R · Niceville, FLS/N 28R-30581N4681KBluestone Ryan Joseph · Lake Havasu City, AZBuilt 1975 · S/N 18263682N4681SRezek William E · Centennial, COBuilt 1979 · S/N R18201377N46828Petro Jerry R · Williamsburg, VABuilt 1953 · S/N 2009N4682DBusch Craig D · Green Brook, NJBuilt 1979 · S/N 17272330N4682JAhz Aviation LLC · Shawnee, KSBuilt 1968 · S/N 28R-30561N4682RTremblay Stanley R Sr · Dexter, MEBuilt 1966 · S/N 28-21441N4682UWaddoups Max E III · Palmer, AKBuilt 1964 · S/N 18051382N4683DAdolph David J · Everly, IAS/N D-4868N4683KKrohn Ronald C · Pauma Valley, CABuilt 1975 · S/N 18263684N4683STorley Christopher · Flower Mound, TXBuilt 1979 · S/N R18201378N4683TBatchelor William · Sicklerville, NJBuilt 1972 · S/N 28-7225199N4684AShilanski Micah V · Wasilla, AKBuilt 1956 · S/N 32281N4684JByrne Matthew A · West Allis, WIBuilt 1968 · S/N 28R-30585N4684SVeracity Aviation LLC · Seguin, TXBuilt 1999 · S/N 2996N4684TMk Aviation LLC · Charlotte, NCS/N R18201733N4685ARegistered aircraftBuilt 1956 · S/N 32282N4685DTopaz Adventures LLC · Rockport, MEBuilt 1956 · S/N D-4895N4685FRulewicz Dennis G · Jackson, MIBuilt 1966 · S/N P206-0285N4685JGaither William W · Shallotte, NCBuilt 1968 · S/N 28R-30586N4685MCbh LLC · Madison, CTBuilt 1978 · S/N D-10143N4685TMalagrifa Richard · Swampscott, MABuilt 1981 · S/N R18201734N4686BThompson Harrison C · Brookings, SDBuilt 1955 · S/N 31584N4686DGarmashov Yuriy · Happy Valley, ORBuilt 1956 · S/N D-4891N4686KMcdonald Robert M · Oak Point, TXBuilt 1975 · S/N 18263687N4686VRegistration Pending · Patterson, LARegistration pendingS/N 172RG0365N4687AMorris Equipment LLC · Yuma, AZS/N 32284N4687JPletcher Enterprises Inc · Muscatine, IABuilt 1968 · S/N 28R-30589N4687RMontz Steven Andrew · Mandeville, LABuilt 1966 · S/N 28-21448N4687SP & V Howard Enterprises LLC · Angleton, TXBuilt 1979 · S/N R18201380N4687VSharp Cutlass LLC · Iowa City, IABuilt 1980 · S/N 172RG0366
Back to AD 2007-04-19 R1