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.

N1629EAnson Air LLC · Sugar Land, TXBuilt 1978 · S/N 17271072 N1629JBuckley Barney P · Colfax, WABuilt 1967 · S/N 28-24016 N1629WRegistered aircraftN-number assigned, not yet registeredS/N TH-245 N162ACWatson Tommy R · Thibodaux, LABuilt 1997 · S/N 1235-97 N162ASA S Air LLC · Lantana, FLBuilt 1978 · S/N 17271785 N162AVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010078 N162AWSchiller Gottfried · Englewood, FLS/N 18-8109082 N162BCRegistration Pending · Tampa, FLRegistration pendingBuilt 2004 · S/N 465-2004 N162BJAircraft Ownership Solutions LLC · Kokomo, INBuilt 1978 · S/N 18266440 N162CPCivil Air Patrol · Maxwell Afb, ALBuilt 2026 · S/N 172S13489 N162CSFrielingsdorf Tim Richard · Manvel, TXBuilt 1998 · S/N 18280192 N162DFFaford Aviation Leasing Co · Atherton, CABuilt 1982 · S/N TJ-403 N162DSDavid Y Stevens · Falcon, COBuilt 2009 · S/N 90695 N162FCSanders Racing Inc · Jasper, ALS/N 135 N162GMMiltenberger Roger J · Sergeant Bluff, IABuilt 1990 · S/N 162 N162HDWolfenden Enterprises Inc · Vero Beach, FLBuilt 1981 · S/N 17274762 N162JKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13466 N162JSPeeler Jason Byron · Floresville, TXBuilt 1980 · S/N 18267510 N162KMerge Mafia LLC · Wall, TXBuilt 1959 · S/N 18-7171 N162LHFarmingdale State College · Farmingdale, NYBuilt 2010 · S/N 2842361 N162MAHearne Scott N · Powderly, TXBuilt 2009 · S/N 3056 N162MDD Squared Aviation LLC · Fort Worth, TXBuilt 1965 · S/N CD-995 N162MEIasco Flight Training Inc · Redding, CABuilt 2000 · S/N 172S8442 N162NBorgen Brian K · Osage Beach, MOBuilt 1966 · S/N TE-154 N162NRBurlington Technical Center · Burlington, VTBuilt 1957 · S/N 32805 N162PCBoard Of Trustees Of Western Michigan University · Battle Creek, MIBuilt 2018 · S/N 4496429 N162PMFrench Loren · Gypsum, COBuilt 1963 · S/N 30-72 N162RVAcord John R · Hattiesburg, MSBuilt 2004 · S/N 23143 N162SUSouthern Utah University · Cedar City, UTBuilt 2024 · S/N 14729 N162VPVirunga Airwing LLC · Washington, DCS/N U20606215 N162WBN162wb LLC · Benton, KSBuilt 1957 · S/N BG-362JS N162WTFly Whiskey Tango 2 LLC · Scottsdale, AZBuilt 1984 · S/N 17276202 N16304Stockmeier Steven J · Liberty Twp, OHBuilt 1973 · S/N 28-7325237 N16305Fross James B · Wichita, KSBuilt 1973 · S/N 28-7305221 N1630CRjd Flyers LLC · Mount Juliet, TNBuilt 1953 · S/N 30330 N1630JPiston Aviation LLC · Saint Charles, MOBuilt 1967 · S/N 28-24017 N1630PSmith Richard D · Williamstown, OHBuilt 1954 · S/N 22-2444 N16311Toxen Robert M · Fort Lauderdale, FLBuilt 1973 · S/N 28R-7335124 N16313Sanders Christopher Scott · Knoxville, TNBuilt 1973 · S/N 28-7310085 N16317Wolf Aviation Network Inc · Westfield, MABuilt 1973 · S/N 28-7325223 N16318Enbom Brian Trustee · Discovery Bay, CABuilt 1973 · S/N 28-7325241 N16319Bethers Michael R · New Market, MDBuilt 1973 · S/N 28-7305224 N1631ESkywarrior Flight Training LLC · Pensacola, FLBuilt 1978 · S/N 17271073 N1631GSwiger Cale W · Hendersonville, TNBuilt 1968 · S/N 127 N1631JReds Aircraft LLC · Edinburg, TXBuilt 1969 · S/N 28-25416 N16320Basurto Kathryn A · Sacramento, CABuilt 1973 · S/N 28-7305225 N16321Chamberlain Frederick L · Tavernier, FLBuilt 1973 · S/N 28R-7335126 N16322Liggett Esaias Martin · Union, KYBuilt 1973 · S/N 28-7310086 N16329Greensite Phillip M · Walton, KYBuilt 1973 · S/N 28R-7335129 N1632CWarren Mark W · Arlington, WABuilt 1953 · S/N 30332

Back to AD 2007-04-19 R1