AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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.
N86AGGarlow Terry J · Granbury, TXN86AQTwo Js Aviation LLC · Moses Lake, WAN86DDJasair LLC · Scottsdale, AZN86DHHolloway'S Tire And Auto Service Inc · Thomaston, GAN86DTEby Cattle LLC · Tonto Basin, AZN86EBBannen Edward · Westerville, OHN86EFCic Aviation LLC · Wenatchee, WAN86HJEarly Bird Aviation Inc · Chicago, ILN86MRThompson Charles E II · Elizabeth City, NCN86RPPetree Aviation LLC · Shreveport, LAN86WEBlue Air 1 LLC · Homestead, FLN8700XOdonnell Daniel V · Dover, DEN8701XThree Green Enterprises LLC · Redondo Beach, CAN8702TWarner Billie J · Fair Oaks Ranch, TXN8703XFlying LLC · Kennewick, WAN8703ZLynch Cody Ryan · Galveston, TXN8704XJohnson Hill A · Euless, TXN8704ZHunt David H · Ortonville, MIN8706ZElliott Michael L · Raeford, NCN8707XTevis David J · Colorado Springs, CON8708XSkylane Flyers LLC · West Jordan, UTN8709XWalton T Michael · Hudson Falls, NYN870PLake Elysian Sky Holdings LLC · Janesville, MNN870PDWings Over West Michigan Inc · Wyoming, MIN8710QMicro Tool Inc · Idaho Falls, IDFirst renewal noticeN8710TWilson Kendal · Carrizozo, NMN8710XDiego Nicholas · Petaluma, CAN8711TFlyabq Aviation LLC · Bella Vista, ARN8711XAbidance Inc · Winthrop, WAN8711ZNeff John Sr · Lumberton, TXN8713TMoreau Darlene A · Penrose, CON8713XLentz Walter E · Duncan, OKN8714TPittman Stuart P · Palisade, CON8714XFrancis Rocky D · Greeley, CON8715ZMarconi Joseph · Hamilton, OHN8716TManchester International LLC · Liberty Lake, WAN8716XKempf Jerry J · Whitefish, MTN8717XStevens Matthew S · Penn Yan, NYN8719ZFedane Rohit · Green Bay, WIN871FBFreebird Leasing Group LLC · Sarasota, FLN871PDJohnson Aircraft Leasing LLC · Springfield, ILN8720THarris Todd D · Malta, IDN8720XSparks Brian Elslie · Monmouth, ORN8722TBarker Bruce L · Liberal, MON8724TStephens Nicholas C · Overgaard, AZN8725QN8725q LLC · Grand Junction, CON8725ZRomine George · Tucson, AZN8727XWallis Aircraft Inc · Clifford Township, PAN8727ZRobertson Reuben · Johnson City, TNN8728XQualls Randy J · Claremore, OK
Back to AD 84-10-01 R1