OpenAirDocs.org
AD 2007-06-01 R1

Registered aircraft · 257

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-06-01-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-06-01-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.

N44ARounds Don DBA · Waller, TXS/N G-723N44MTFree Fliers Ma LLC · Sheridan, WYS/N G-11N44YHansen Kenneth · Irvine, CAS/N G-760N4534MFowler Bruce Jr · Cedar Park, TXBuilt 1956 · S/N 58-11088 (FM88)N45DTKaher Kevin · Groveland, CAS/N G-785N45GSLinde Aviation LLC · Payson, AZBuilt 1953 · S/N 34-76N45TBGooney Bird Group Inc · Templeton, CABuilt 1956 · S/N BG-235N488JFMentoraire LLC · Lake Forest, CABuilt 1953 · S/N G-298N4944CCoke Richard · Bedford, TXS/N BG-283N4945CFandango Ranch Operating Co Inc · Bend, ORS/N BG-234N4982NReirdon Michael Shawn · El Cajon, CABuilt 1953 · S/N 53-4095N4984Hobschaidt Kurt J · Pittstown, NJBuilt 1955 · S/N JS-611N4985Crawford Loel H · La Follette, TNBuilt 1953 · S/N 34-125N4WLOstrich James T · Redding, CAS/N G-127N500DRFox 2 Inc · West Chicago, ILBuilt 1954 · S/N G-31N5070KSmith Alice B · Escondido, CAS/N G-65N5172Beitler William J · Washington, PABuilt 1955 · S/N G-729N51TTThumann Wayne E · Weimar, TXBuilt 1981 · S/N BG-107N5268Evans Eric A · Saint Peter, MNBuilt 1955 · S/N G-825N5347WAmerican Airpower Heritage Flying Museum · Dallas, TXBuilt 1955 · S/N G275N534BWBilmar Avionics Inc · Kissimmee, FLS/N G-63N534CBZahler Steven E · Manning, SCBuilt 1953 · S/N 53-4154AN534DBBerry Darrel · Camden, TNBuilt 1958 · S/N CG-207N534RBCloud 9 Wings LLC · Webberville, MIBuilt 1953 · S/N G-300N534YWahl Charles S · Cameron Park, CAS/N BG-70N5361GBaker Kimberly L · Monticello, INS/N BG-55N53BRLl53 LLC · Naperville, ILBuilt 1953 · S/N G-152N53ZZRussell Military Museum · Zion, ILS/N G-279N54654American Flight Museum · Topeka, KSS/N BG-247N54HThb34 LLC · Kalispell, MTBuilt 1953 · S/N 34-80N54RFFrasca Lucille A · Urbana, ILBuilt 1957 · S/N G-140N555ZZUnited States Air Force · Rio Vista, CABuilt 1953 · S/N G-290N55626Compton Randel D · Gulf Breeze, FLBuilt 1955 · S/N 34-95N557DBMentor One LLC · Englewood, FLS/N G-789N562LSale Reported · Dover, DESale reported, canceledS/N BG-115N563DPSmith James E Trustee · Kalispell, MTBuilt 1962 · S/N 53-4114AN56NTJet Air Inc · Iowa City, IABuilt 1955 · S/N G-778N5734BGrinnell Chris · Willis, TXBuilt 1956 · S/N BG-365N574Yunt David W · Springboro, OHBuilt 1956 · S/N G-831N57ZZUnited States Air Force Owner · March Arb, CABuilt 1957 · S/N BG-323N58743Dutchess Community College · Poughkeepsie, NYS/N BG-239N5QNGreatest Generation Naval Museum · Colorado Springs, COBuilt 1955 · S/N BG-6N5RYLazy Ta Legend Aircraft LLC · Wilmington, DEBuilt 1960 · S/N BG-421N617KGKolp Timothy J · Hendersonville, TNS/N BG-279N63492Northware Ventures Inc · Hidalgo, TXS/N G-32N634DBFisette James · Holladay, TNBuilt 1960 · S/N BG386N634JWRohlmann Michael S · Saint Louis, MOS/N G-801N634MGeorge Mike J · Springfield, ILBuilt 1955 · S/N G-761N638LLFire Island Flight LLC · Islip, NYS/N G-93N638TDMentair Inc · Napoleon, OHBuilt 1953 · S/N G-286
Back to AD 2007-06-01 R1