AD 2016-22-01
Registered aircraft · 75
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:2016-22-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-22-01')
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:2016-22-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-22-01') 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.
N100KMSorenson Daniel K · Tucson, AZN102HSRegistration Pending · Castle Rock, CORegistration pendingN103JDenman David H · Gainesville, FLN104JLReilly David J · Richmond, VAN106DEIcarus 5280 Soaring LLC · Fort Worth, TXN114QCupp Cecil W III · Hot Springs, ARN114TWSaunders Christopher D · Lehighton, PAN11WXPinney Charles W · Tucson, AZN1235Misch David · Bartow, FLN123HHMclaughlin Patrick Lee · Redmond, ORN127DGBrooks Todd P · White Lake, MIN129PGDonnelly Mark S · Goodyear, AZN130CWWard Allen M · Andalusia, ALN140BHRegistered aircraftN144JSullivan Brent · Houston, TXN150MESandhill Soaring Club Inc · Brighton, MIN157KShelton Steven D · Washington, DCN15VHLehmann Lawrence W E · Pittsburgh, PAN163AFUsaf Academy · Usaf Academy, CON164AFUsaf Academy · Usaf Academy, CON165AFUsaf Academy · Usaf Academy, CON16MAKeil Carl · Granbury, TXN200DXOpitz Michael R · Freehold, NYN200XMarcus Hook Glider Works · Wilmington, DEN204JGGreer John M Jr · Mercer Island, WAN208UVaughn Michael E · Johns Creek, GAN212VBFurdal Lukasz · Hillsborough, NJN223GCKobiesa Jacek · Pasco, WAN257SBDuncan Marvin H Jr · Marblehead, MAN262CTKobilsek Peter P · Bella Vista, ARN272BLFrechtling Andrew C · Waxahachie, TXN27GGYeldezian Glenn H · The Woodlands, TXN28WGGeiger William D · Pittsburgh, PAN29PSWalling Reigh A · Clifton Park, NYN322DFHollenberg Randall W · Houston, TXN328TWAlspaugh George J · Pfafftown, NCN34GJHarbold Michael E · Washington, DCN41REEckel Robert W · Centerville, UTN449TZRussell Jeffrey R · Chicago, ILN460GHGoulding Haven H Jr · Howard, PAN47EHHalimi Emil · Bell, CAN483AHAnderson Herman S · Flowery Branch, GAN51CRJaeger Dieter · Decatur, GAN523RRGlenn Tom · Fallbrook, CAN52BXReinecke Eugene · Park City, UTN52FRPascale Frank R · Glen Cove, NYN547CMArnold Sarah D · Benton, TNN552RMTedeschi Francesco Trustee · Del Mar, CAN57LKSky Sailing Inc · Warner Springs, CAN58HRNorris James M · Santa Barbara, CA
Back to AD 2016-22-01