AD 2016-05-13
Registered aircraft · 3,126
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-05-13')
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-05-13')
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-05-13') 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-05-13') 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.
N804WWWhirlwind Aviation Inc · Fisher, ARN8057PMulder Air Inc · Renville, MNN8058LMontague Aviation LLC · Inverness, MSN80595Standridge Flying Service Inc · Lake Village, ARN805ASRice Flying LLC · Poplar Bluff, MON805DGWakefield Aircraft LLC · Cooperstown, NDN805DZSeattle Aircraft Rentals LLC · Bellevue, WAN805ELKenmore Crew Leasing Inc Trustee · Bellingham, WAN805ETArc Aviation Of Texas LLC · Winnie, TXN805HBKansas Farm And Ranch Inc · Seneca, KSN805KPTidwell Flying Service Inc · Carlisle, ARN805RXRegistration Pending · Norcross, MNRegistration pendingN805THAvion Capital Corp · Anchorage, AKN806BABombero Aviation LLC · Childress, TXN806EBDakota Air Spray LLC · Huron, SDN806JASomething Aviation LLC · Dekalb, ILN806JMFlorida Fish & Wildlife Conservation Commission · Lakeland, FLN806KMMontana Aircraft Trust Inc Trustee · Bozeman, MTN806KPWild Rice Air Ag Inc · Rutland, NDN806LWSac Wild LLC · Loomis, CAN806WBCircle I Air LLC · Lubbock, TXN807BBAgritec Aviation LLC · Deering, NDN807FERegistration Pending · Mountain View, CARegistration pendingN807HAAerial Applicators Of Missouri LLC · Qulin, MON807JAAv Serv LLC · Dover, DEN807KPForest Flying Service Inc · Langdon, NDN807RXHog Air Aviation Inc · Paragould, ARN808HBKansas Farm & Ranch Inc · Seneca, KSN808RXHog Air Aviation Inc · Paragould, ARN808SWFmgi Inc · Woodstock, GAN808TRTrans Executive Airlines Of Hawaii Inc DBA · Honolulu, HIN8096UWhitty Aviation LLC · Rocklin, CAN809BBBear Bayou Ag Service Inc · Middletown, DEN809KCMid-Atlantic Aircraft Leasing LLC · Wilmington, DEN809RXAg Air Aircraft Inc · Paragould, ARN809SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN80MALsc Construction Inc · Perris, CAN80PFProducers Flying Inc · Louise, MSN80PMSouthbreeze Aviation LLC · Wellington, FLN80TMRad Holding I LLC · Olympia, WAN810EBRegenald Michaud Aviation LLC · Willows, CAN810RXNeal Aircraft Inc · Slaton, TXN810VJVee Jay Equipment (De) LLC · Clarkston, MIN8116NStingray Aviation LLC · Visalia, CAN811TPJ & J Air Service LLC · Jonesboro, ARN811VMGuardian Flight LLC · Lewisville, TXN812ASRice Flying LLC · Poplar Bluff, MON812EBRice Flying LLC · Poplar Bluff, MON812KAHowatt Air Inc · Langdon, NDN812NSTri Rotor Spray & Chemical Inc · Ulysses, KS
Back to AD 2016-05-13