AD 2016-22-06
Registered aircraft · 467
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-06')
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-06')
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-06') 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-06') 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.
N408BLN767ds LLC · Richmond, VAN413BL413 Bravo Lima LLC · Worcester, MAN413LAN925lr LLC · Palatka, FLN419BLSkywarrior Flight Training LLC · Pensacola, FLN421BLM4 Aviation LLC · Kutztown, PAN421MQTake Flight Aviation LLC · Montgomery, NYN422BLBlue Line Aviation LLC · Winter Haven, FLN426YPAnodyne Of Savannah LLC · Newark, DEN42KHPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN42MVVonaviation Group Vi N42mv LLC · Lewes, DEN42NGRegistered aircraftN42VJThink Aerospace LLC · Boulder, CON434LA1229 Holdings LLC · Fort Collins, CON434SAMitchell Street Aviation Inc · Madison, WIN435LAWe Aviate LLC · Woodleaf, NCN437HIll Fly Away LLC · Goshen, INN438LLift Aircraft LLC · Carmel, INN43ASSkyline Aviation Inc · San Angelo, TXN43WFAerospace Trust Management LLC · Wilmington, DEN441SAChen Aviation Inc · Princeton, NJN442ADWingsleasing LLC · Wichita, KSN442RCPremier Aircraft Sales Inc · Fort Lauderdale, FLN443JContrail Inc · Bethlehem, PAN443LLift Aircraft LLC · Carmel, INN445LLift Aircraft LLC · Carmel, INN446LLift Aircraft LLC · Carmel, INN447PJPapa Juliet Aviation LLC · Marblehead, MAN44HHN44hh LLC · Tuckahoe, NYN452LLift Aircraft LLC · Carmel, INN454MNow Energy Systems Corp · Rhinebeck, NYN457SABasils Best Flights LLC · New Cumberland, PAN458LLift Aircraft LLC · Carmel, INN45ASSkyline Aviation Inc · San Angelo, TXN469BLSkywarrior Flight Training LLC · Pensacola, FLN470BLSkywarrior Flight Training LLC · Pensacola, FLN471BLBlue Line Aviation LLC · Morrisville, NCN472BLSkywarrior Flight Training LLC · Pensacola, FLN473BLSkywarrior Flight Training LLC · Pensacola, FLN474BLSkywarrior Flight Training LLC · Pensacola, FLN475BLSkywarrior Flight Training LLC · Pensacola, FLN478SAM U D Y Properties LLC · Helena, MTN479WPSnow Hill Aviation LLC · Baroda, MIN481MRWings Level Aviation LLC · Lake Mary, FLN484MFPeregrine Howard Aeroflight Owner LLC · New Orleans, LAN485SVLima Alpha Struck LLC · Durham, NCN487SAInvestment Properties Expeditions LLC · Rockville, MDN488SAWild Blue Yonder LLC · South Bend, INN499BWGallagher Homes LLC · Chapel Hill, NCN49AUAurora Flight Sciences · Manassas, VAN505FMSeabreeze Mc LLC · East Islip, NY
Back to AD 2016-22-06