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.

N3703YWilemon Ronald J · Tulsa, OKBuilt 1963 · S/N 21058203N3704ACousin Sydney Louis Jr · Renton, WABuilt 1970 · S/N E-202N3704GGap Holdings LLC · Dover, DEBuilt 1980 · S/N EA-145N3704MLacroix Robert Emile Jr · Orlando, FLS/N 28R-7837130N3704PAlderman Mark C · Wasilla, AKBuilt 1955 · S/N 22-3420N3704QRipley Robert G · Griffin, GABuilt 1966 · S/N D-8365N3704TStevens Michael J · Punta Gorda, FLBuilt 1967 · S/N 28R-30008N3704ZGray Melinda G · Milan, ILBuilt 1960 · S/N 22-7573N37050F33a Partners LLC · Holderness, NHBuilt 1980 · S/N CE-926N3705FMonteith Andrew W · Lebanon, PABuilt 1977 · S/N 0750N3705QCourts Data Center Consulting LLC · Lakeway, TXBuilt 1967 · S/N D-8419N3705TN3705t LLC · Dallas, TXBuilt 1967 · S/N 28R-30009N3705YMunoz Concepcion · Tulsa, OKBuilt 1963 · S/N 21058205N3706KRegistration Pending · Cedar City, UTRegistration pendingBuilt 1967 · S/N 28-23699N3706NJsn Aviation LLC · Huntersville, NCBuilt 1967 · S/N 680044N3706QSteed George W III · Silverdale, WABuilt 1966 · S/N D-8367N3706TFinished Work Aviation LLC · Redding, CABuilt 1967 · S/N 28R-30010N3706UBrownfield Ken F · Boonville, MOS/N 18255106N3706YAlexander Steve Craig · Shreveport, LABuilt 1963 · S/N 21058206N3706ZHall John L · Port Angeles, WABuilt 1960 · S/N 22-7575N3707AMorris Charles W · Wasilla, AKFirst renewal noticeBuilt 1958 · S/N 18-3388N3707DWilliams Charles S · Pearland, TXS/N 34407N3707PHamm Russell K · Owasso, OKBuilt 1955 · S/N 22-3423N3707QTroutman Shaun · Johnson, KSBuilt 1966 · S/N D-8368N3707TFisher Kurt A · San Luis Obispo, CABuilt 1970 · S/N TH-110N3708AFreyburger Paul W · Java Village, NYBuilt 1956 · S/N 18-3389N3708KWard Ron · Oklahoma City, OKBuilt 1980 · S/N EA-153N3708PAeromarine Consulting Inc · Brandon, FLBuilt 1955 · S/N 22-3424N3708UCollins George H · Murfreesboro, TNBuilt 1963 · S/N 18255108N3708XHammon Justin M · Colorado City, AZBuilt 1968 · S/N 5009N3708ZReisman Richard H · Montrose, COBuilt 1960 · S/N 22-7577N37091Lee James P · Madisonville, TNBuilt 1980 · S/N E-1761N3709DAbidance Inc · Winthrop, WABuilt 1957 · S/N 34409N3709NShow Me The Mooney LLC · Hartford, KYBuilt 1967 · S/N 680045N3709TJudice Eric M · Elgin, ILFirst renewal noticeBuilt 1967 · S/N 28R-30013N3709UMoser Scott M · Pisgah Forest, NCS/N 18255109N370ACNuza Philip A · Sidney, MEBuilt 2000 · S/N 433-99N370AJCoyne Patrick J · Tuam Co CalwayNon-citizen corporation, flight hours not reportedBuilt 1977 · S/N 2929N370BBBuffalo Biodiesel Inc · Tonawanda, NYBuilt 2023 · S/N 14593N370BFDaal Inc · Wilmington, DEBuilt 2004 · S/N 6065N370BLWingsleasing LLC · Wichita, KSBuilt 2024 · S/N 2881770N370CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N 18282000N370DLLee David · Skaneateles, NYBuilt 2024 · S/N 02210162N370FLFingerlakes Wing And Rotor LLC · Seneca Falls, NYS/N 3726N370GAir Land Ventures LLC · Highland Park, ILBuilt 2003 · S/N 0783N370HMHoneybee Helicopters LLC · Kalispell, MTBuilt 2005 · S/N 10914N370JCSouth Oaks Inc · Hollywood, FLBuilt 1977 · S/N U206-04024N370JGGuideair LLC · Eden Prairie, MNBuilt 2004 · S/N 1123N370JHNational Aircraft Leasing Corp · Greenville, DEBuilt 2009 · S/N 18282191N370K370k LLC · Bethany, OKBuilt 2026 · S/N 172S13481
Back to AD 2007-04-19 R1