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.

N1632EXin Han Aviation LLC · Atwater, CABuilt 1978 · S/N 17271074 N1632HM & B Aero LLC · York, PABuilt 1977 · S/N 28-7790319 N1632JDavid A Bowden · Duncan, OKBuilt 1968 · S/N 28-24019 N1632MD&J Training Planes LLC · Logan, UTBuilt 1975 · S/N 18264398 N1632PWilley Larry E · Fremont, OHBuilt 1954 · S/N 22-2446 N1632WCdg Aviation LLC · Cresson, TXBuilt 1972 · S/N D-9363 N16332Brown Chritopher M · Lake Helen, FLBuilt 1973 · S/N 32-7300023 N1633CUS Aviation Training Solutions (Usats) · Titusville, FLBuilt 2005 · S/N 0208 N1633MHill David A · North Ridgeville, OHBuilt 1975 · S/N 18264399 N1633XRhodes Donald P · Fort Worth, TXBuilt 1975 · S/N 21060669 N16340Schwartz Gregg M · Ambler, PABuilt 1973 · S/N 28-7325245 N16341Schmitz Frederick · Atlanta, GAS/N 28-7325246 N16343Starlight Real Estate Investments Inc · Punta Gorda, FLS/N 115 N16348Mcelyea Shawn T · Aledo, TXBuilt 1973 · S/N 28-7325249 N1634JLemaire Norman J Jr · Taunton, MABuilt 1968 · S/N 28-24021 N1634WTaglieri Ronald F · Pass Christian, MSBuilt 1972 · S/N D-9378 N1634XBadwater Ranch Inc · Lysite, WYBuilt 1975 · S/N 21060670 N16350Dunn Mitchell R · Hayden, ALS/N 28-7305229 N16351Degraaff Norman L · Friday Harbor, WABuilt 1973 · S/N 28-7305231 N16357Ktup Aviation LLC · Belden, MSBuilt 1973 · S/N 28-7325253 N16359Skinner Colin L · Hartland, VTBuilt 1973 · S/N 28-7305233 N1635JDalsco Inc · Dover, DES/N 28-24820 N1635PRegistered aircraftN-number assigned, not yet registeredS/N 82384 N1635WTullos Hugh S III · Oklahoma City, OKBuilt 1972 · S/N E-350 N16361Fly 361 LLC · Doswell, VABuilt 1973 · S/N 28R-7335134 N16362Flightline Air Service LLC · Pineville, LABuilt 1973 · S/N 28R-7335135 N16363Bloemker Edward L · Fremont, NEBuilt 1973 · S/N 28-7310090 N16365Harding Keith A · Newport News, VABuilt 1973 · S/N 28-7325255 N16367Swartzbacker Paul · New Lenox, ILBuilt 1973 · S/N 28-7305237 N16368Tougas William E · Timberlake, NCBuilt 1973 · S/N 28R-7335136 N1636BOlson Lance E · Hillsboro, ORBuilt 1999 · S/N 2700 N1636XMonke Farm & Cattle Co · Nickerson, NEBuilt 1975 · S/N 21060672 N16371Melendy Corey Wayne · Enid, OKBuilt 1973 · S/N 28-7310091 N16374Milliard Craig R · Benicia, CABuilt 1973 · S/N 28-7305238 N16377Jones Aaron M · Conrad, MTBuilt 1973 · S/N 28-7310092 N16378Lapair Inc · Vero Beach, FLBuilt 1973 · S/N 32-7300026 N1637CAshby Clark S · Pleasant Grove, UTBuilt 1953 · S/N 30337 N1637EJag Flying Club Inc · Morgantown, WVBuilt 1978 · S/N 17271077 N1637GLejeune Robert S · Basile, LABuilt 1968 · S/N 113 N1637TSmith Taylor · Amarillo, TXBuilt 1973 · S/N 414-0417 N16382Reick Gregg G · Minnesota City, MNBuilt 1973 · S/N 28-7325259 N16385Haines Michael C · Wadsworth, OHBuilt 1973 · S/N 28-7305242 N16387Anderson Jeffrey J · Hartland, WIBuilt 1973 · S/N 28-7310093 N1638JSmith Bryan Alexander · Cabot, ARBuilt 1967 · S/N 28-24026 N16393Parker Owen · Collyer, KSBuilt 1973 · S/N 28-7325264 N16395Oak Ridge Flyers Inc · Oak Ridge, TNBuilt 1973 · S/N 28R-7335141 N16396Nobrainer Holdings LLC · Fort Lauderdale, FLBuilt 1973 · S/N 32-7300027 N16398Withers Harry R · Beaufort, SCBuilt 1973 · S/N 28-7305244 N1639GGhostwriter Airshows LLC · Hustonville, KYBuilt 1968 · S/N 115 N1639JAll American Aviation Services Inc · Fayetteville, NCBuilt 1967 · S/N 28-24027

Back to AD 2007-04-19 R1