Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,428

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N1981TWatson Barrett Consulting LLC · Hermitage, TNS/N 28-7105201 N1981XB2 Aviation LLC · Sisters, ORBuilt 1965 · S/N 18256081 N19820Su Zaihao · Auburn, WABuilt 1972 · S/N 17260783 N19824Gadola Alan J · Maple Grove, MNBuilt 1976 · S/N 17702605 N19828Walker Clint · Indianapolis, INBuilt 1976 · S/N 17702606 N1982DHarm David A · Marathon, WIBuilt 2021 · S/N 90819 N1982RLaughlin Michael · Anchorage, AKBuilt 1975 · S/N U20602913 N1982XWheeler Joseph T · Chandler, AZS/N 18256082 N1982YSale Reported · Mount Pleasant, SCSale reportedBuilt 1964 · S/N 269 N19830Vainosky Michael A · Fort Johnson, NYBuilt 1972 · S/N 17260789 N19833Tri Star Aviation Inc · Nashua, NHBuilt 1972 · S/N 17260791 N19837Kerrick Wallace Glenn Lee · Miami, FLBuilt 1972 · S/N 17260793 N19838Finegan Charlene · Whitehouse Station, NJBuilt 1972 · S/N 17260794 N19839Marlin Air Corp · Tavernier, FLBuilt 1972 · S/N 17260795 N1983CRivera Carlos A · Morriston, FLBuilt 1955 · S/N 31572 N1983FSports Flyers Association Inc · Schenectady, NYBuilt 1984 · S/N 17276134 N1983LWindsor Aero Holdings LLC · Columbia, SCBuilt 1976 · S/N M-1841 N1983UAlpine Air LLC · Cordova, AKBuilt 1970 · S/N 18501731 N1983VHenniker Flying Club · Concord, NHBuilt 1974 · S/N 17263812 N1983WTailwinds LLC · Houston, TXBuilt 1988 · S/N E-2423 N19840Tri-Star Aviation Inc · La Porte, TXBuilt 1972 · S/N 17260796 N19841Sale Reported · Sheridan, MISale reportedBuilt 1972 · S/N 17260797 N19842Ocala Services Inc · Ocala, FLBuilt 1972 · S/N 17260798 N19847Wheatley William L · Springfield, KYBuilt 1976 · S/N 17702607 N19848Bell Thomas D · Unalaska, AKBuilt 1972 · S/N 17260801 N1984TGettelfinger Bart A · Indianapolis, INBuilt 1971 · S/N 28-7105202 N1984X140kts LLC · Quilcene, WABuilt 1965 · S/N 18256084 N19850Harbour Aviation LLC · Weatherford, TXBuilt 1972 · S/N 17260803 N19854Boris Jeffrey A · Troy, MIBuilt 1972 · S/N 17260807 N19857Rutledge James M · Cresson, TXBuilt 1976 · S/N 17702608 N1985CCollins Bruce J · Caldwell, TXS/N D-7438 N1985MSokalsky Leigh Anne · Monee, ILBuilt 1976 · S/N 18264514 N19860Rvb71 LLC · Braxton, MSBuilt 1972 · S/N 17260812 N19861Thomas Edward R · Piney Flats, TNS/N 17260813 N19865Carlson Richard M · Tierra Verde, FLBuilt 1972 · S/N 17260816 N19866Hurlin Nicholas E DBA · Newburyport, MABuilt 1972 · S/N 17260817 N19867Georges Aviation Services Inc · Honolulu, HIS/N 17260818 N19868Code4 Ventures Inc DBA · Waynesboro, VABuilt 1972 · S/N 17260819 N1986LPhillips Alan K · Junction City, ORBuilt 1976 · S/N M-1843 N1986TCarroll Douglas R · Mount Pleasant, NCBuilt 2001 · S/N 5548 N19878Oxford Flying Club LLC · Oxford, NCBuilt 1972 · S/N 17260827 N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544 N1987LBig Bend Community College · Moses Lake, WABuilt 1976 · S/N MB-806 N1987WWood Wilbur L · Alachua, FLBuilt 1974 · S/N MB-663 N1987YTipton Inc · Turners Station, KYBuilt 1964 · S/N 274 N19880Mach 1 Pilots Association Inc · Hillsborough, NJBuilt 1977 · S/N 17702610 N19881Nichols Philip · Royse City, TXBuilt 1972 · S/N 17260830 N19882Morris Robert Alexander · Carencro, LABuilt 1972 · S/N 17260831 N19886Silver Express Co · Miami, FLBuilt 1972 · S/N 17260834 N19887Kidd Joseph N · New Smyrna Beach, FLBuilt 1972 · S/N 17260835

Back to AD 2007-04-19 R1