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.
N6824RSquadron 5 Inc · Saratoga, CAN6826BDan Howard Aircraft Sales LLC · Tulsa, OKN682ASRegistration Pending · Stony Brook, NYRegistration pendingN682SBSundowners Inc · Fort Myers, FLN682SPHansell Stephen E · East Windsor, NJN6830MJ & J Air LLC · Laurel, MSN6830RElizalde Carla Zankiz · Estero, FLN6831MSouth Beach Adventure Sports LLC · Bald Head Island, NCN6832RWheeler David G Jr · Chico, CAN6835MMgadi LLC · Trenton, MIN6839MKulton Jon T · Somonauk, ILN683JWLotela Partners LLC · Avon Park, FLN6840MFlying R Aviation LLC · Trenton, MON6842MBognar John A · Belgrade, MTN6843RArkansas Air LLC · Jackson, WYN6844MBarker Edward J · Claremore, OKN6847RAlpine Aviation LLC · Oklahoma City, OKFirst renewal noticeN6848MFitts Wayne T · Independence, ORN684CPCivil Air Patrol · Maxwell Afb, ALN684MCT&B Aero LLC · Jacksonville, FLN684SSecond Wind Aviation Corp · Friday Harbor, WAN6850BJennings Donald J · Gypsum, CON6851R6851r LLC · Greeley, CON6852RJensen Sid R · Idaho Falls, IDN6855RD & N Holdings Inc · Boca Raton, FLN6856MWoodall Larry Douglas · Auburn, WAN6857DDynamic Aerospace Inc · Framingham, MAN6857MRegistration Pending · Lenoir City, TNRegistration pendingN6857RRegistered aircraftN6858EMalara Steven · Frankfort, NYN6859MRegistration Pending · Woodruff, SCRegistration pendingN6859RRomeo Airmotive LLC · Stockton, CAN685ACMullerhill Inc · Hillsboro Beach, FLN685GTEatmb Air Inc Trustee · Wilmington, DEN685JMBallard Aviation · Waynesville, MON685LACorr Joshua · Santa Paula, CAN685SSecond Wind Aviation Corp · Friday Harbor, WAN6861MEwing Aviation LLC · Ellisville, MSN6861RJohnson Bradley Michael · Belgrade, MTN6862MCreacy Jason Thomas · Gatesville, TXN68639Bathalter Michelle N · Las Vegas, NVN6863MRvandco LLC · Missoula, MTN6864MKnott Dustin Shane · Brentwood, CAN6864RRankin Bryan · Cloverdale, CAN6866ROrnes W Harold · Aiken, SCN6868LJohnson Gregory L · Orange, CAN6868RChrisman Charles Griggs · Denver, CON6870LBarr Air Patrol LLC · Mesquite, TXN6870MApplied Science Services Corp · Woodland Hills, CAN6872GVortex Aircrafts Inc · Port Saint Lucie, FL
Back to AD 84-10-01 R1