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.
N613PFGeorgia Forestry Commission · Macon, GAN613TLSams Aircraft LLC · Fredonia, KYN613WDCruse Josiah L · Rainier, ORN613YHKuspuk School District · Aniak, AKN6141BPayne Jacqueline · Minden, NVN6143BRushing Harley J III · Cheraw, SCN6144BRieser Robert · Aurora, ILN61455Hutcheson David Carl · Santa Rosa Beach, FLN6145SPlaney Mcplane Face LLC · N Richlnd Hls, TXN6146BMiles From Ordinary LLC · Auburn, WAN61474Harper Analeasa Leighan · Clarksville, TNN6147BMock David J · Mesa, AZN6147FHenry Charles C · Portland, TNN6148FWorsham Eric S · La Porte, TXN6149EOliphant John R · Houston, TXN6149SScheller Kenneth R · Glassport, PAN614MBStarlight Express LLC · Bellevue, WAN614WMCarbonell Terry L · Alva, FLN6151BCasey Ross H · Boise, IDN6151RPath Barney H DBA · Claremont, CAN6151UMccall John A · Grapeland, TXN6151YBulloch Troy P · Cedar City, UTN6152BMohave County Board Of Supervisors · Kingman, AZN6152FFisher Wayne G Trustee · Gainesville, FLN61537Coplin Christopher S · Anchorage, AKN6153BCenturion Southeast Management LLC · Raleigh, NCN6153RSummers Don · Moose Lake, MNN6153ZJaars Inc · Waxhaw, NCN6154BChenoweth Lane Trustee · Anchorage, AKN6154NDouer Isaac R · Miami, FLN6155BPelzer Michael J · Rochester Hills, MIN6155EShiloh Flying Club Inc · Blandon, PAN6155RPlane + Simple LLC · Salt Lake City, UTN6155YAl & Zal Corp · Wilmington, DEN6156BRumple Richard A Jr · Angola, INN61576Nelson Bruce T · Healdsburg, CAN6157SKearley Christopher · Assonet, MAN6158RMahany John C · Yucca Valley, CAN61599Freebird Aviation LLC · Eagle, IDN6159ULaw Office Of Vincent G Rieger · Kalispell, MTN615ESCampanell Garrett · Leesburg, VAN615FUN615fu LLC · Nashville, TNN615TWClark Jim W · Claremore, OKN616U S D A Forest Service Fepp · Columbia, SCN6160BJesperson Kenneth R · Ekalaka, MTN6160NRj Capital LLC · Mustang, OKN6161BPeterson Tony D · Humboldt, IAN6161FBeach Bums Air LLC · Martin, GAN6161NOn Eagles Wings LLC · Los Gatos, CAN6161STeklinski Andrew · Indian River, MI
Back to AD 84-10-01 R1