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.
N6180UParrish Aerial Services LLC · Wilmington, DEN6181QPioneer Agviation 2 LLC · Holdrege, NEN6182AA&R Air Inc · Hinsdale, ILN618JCMclean Aviation Services Inc · Napa, CAN618LAMiles Flying Service Inc · Bono, ARN618MAAir Matrix LLC · Lomita, CAN618SLewis Aeronautical LLC · San Antonio, TXN619LAArg Aviation LLC · Lexa, ARN619PAPafford Air Of Mississippi LLC · Ruston, LAN619PFDel Ag Aero LLC · Milton, DEN619TKRegistered aircraftN61DJBlack Badge Aviation LLC · Carson City, NVN61DNDn2 Aviation LLC · Fernandina Beach, FLN61KATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN620NRak Tbvr LLC · Middletown, DEN620WALaboratory Corporation Of America Holdings · Burlington, NCN6215MGrant County Mosquito Control District #1 · Moses Lake, WAN621GZHfjw Properties Leasing LLC · Santa Rosa Beach, FLN621NHorizon Aviation LLC · Kalispell, MTN622AWSale Reported · Prattville, ALSale reportedN622FCRegistered aircraftN-number assigned, not yet registeredN622KABank Of Utah Trustee · Salt Lake City, UTN622KMK & M Equipment Co LLC · Chatsworth, CAN62370Bell Flying Inc · Newport, ARN623BALmco · Vandenberg Afb, CAN623BFHiggins Leasing Inc · The Woodlands, TXN623LANeal Aircraft Inc · Slaton, TXN623RBAvag Inc · Richvale, CAN626FCFlorida Department Of Agriculture And Consumer · Tallahassee, FLN626LMOne Percent Aviation LLC · Lewes, DEN626NDay William B · Conroe, TXN626TSChorman Spraying LLC · Milton, DEN62764Bell Flying Inc · Newport, ARN627EHHound Dog Enterprises LLC · Terre Haute, INN627LANew Frontier Aviation LLC · Fort Benton, MTN627PCAir First LLC · Kalispell, MTN628FAAkbj LLC · Lewes, DEN628MCAir Methods LLC · Greenwood Village, CON629AAAllen Aviation Inc · Aynor, SCN629JPLj Leasing LLC · Cardington, OHN62HQGreen And White Air LLC · Kalamazoo, MIN62LMBroadway Air LLC · Huntsville, ALN62LTLima Tango LLC · Mariposa, CAN62SALta Group Holdings LLC · Amarillo, TXN630LLCroom Aviation LLC · Port Saint Joe, FLN631BLBancfirst · Oklahoma City, OKN634BTurbo Air Charter LLC · Boise, IDN63593Rbr Development LLC · West Plains, MON635BDodson International Parts Inc · Rantoul, KSN6366SUS Special Operations Command · Macdill Afb Tampa, FL
Back to AD 2016-05-13