AD 99-05-13 R1 WD
Registered aircraft · 13,518
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:99-05-13-R1-WD')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD')
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:99-05-13-R1-WD') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:99-05-13-R1-WD') 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.
N725ADSisson David Brent · Lubbock, TXN725APSheets Douglas · Goodyear, AZN725BRussell Charlie N · Palestine, TXN725DAndrews Christopher · Parker, CON725YFiumara Joseph A · Lake Havasu City, AZN7260BWheatley Albert W · Wilmington, DEN7264BRutter David · Downers Grove, ILN7267BInnovative Aviation Services Inc · Newnan, GAN7268RRural-Em Consulting Inc · Dallas, TXN726AGTwo Tails LLC · Las Vegas, NVN726BADangerstik Corp · Olympic Valley, CAN726BGDusty Bg LLC · Greensboro, NCN726DRodriguez Gustavo · Pearland, TXN726TJJohnstone Thomas T · Panama City, FLN7271BHanks Donald V · Camp Verde, AZN7272BD O K Aero Inc · Wayland, MIN7273BJ35 Aviation LLC · Wichita, KSN7273RHarwood Nathan S · Roanoke, TXN7274BWildingwood Grove LLC · West Bend, WIN7274RChastain Phillip L · St Louis, MON7277BRoberts Nathan W · Cleveland, OHN7278BWilkins William B · Mayodan, NCN727AVSkyline Eighteen LLC · Setauket, NYN727BVWheels Up Aviation LLC · Madison, MSN727CBDwr Aviation Enterprises LLC · Vero Beach, FLN727EGTalor Darrell T · Dawsonville, GAN727LTFoster Jeffrey · Baton Rouge, LAN727MSRedd Aviation LLC · Elk City, OKN727PLeading Edge Flight Academy LLC · Bend, ORN727QReinhard Ryan B · Hillsboro, TXN727TBeechair LLC · Lake Tapps, WAN727VDli Aviation LLC · St George, UTN727WMMd Air Ops LLC · High Springs, FLN7280BClk Aviation LLC · Henderson, NVN7282BArsuf LLC · Missoula, MTN7283RUltra Motorsports II · Boerne, TXN7285BEasy Pz Aviation LLC · Monroe, GAN7286RHulands Gregory G · Eagle Point, ORN7287RTailwinds Inc · Norwalk, IAN7289BMotown Inc · Fort Worth, TXN7289RThompson John · Keller, TXN728HMSchott Brian M · Hayward, CAN728RHBearce Kristin Priscilla · Kissimmee, FLN728VAero Research LLC · Kalispell, MTN7293BBealmear Travis Lane · Fort Collins, CON7294BKelley Robert D · Barstow, CAN7295BBonanza Flyers Inc · Sioux City, IAN7296BChaney Paul A · Oklahoma City, OKN7298RWhite Barry · Runaway Bay, TXN7299RLindeman Russell L DBA · D Hanis, TX
Back to AD 99-05-13 R1 WD