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.
N8213VRiver City Real Estate LLC · Otis, MEN8215ZRg Aviation Inc · Wilmington, DEN8217GVne Aviation LLC · Dripping Springs, TXN8217MBas Part Sales LLC · Greeley, CON8219MFair Winds Group LLC · Portage, MIN821CETedesco Michael Anthony · Monroe, CTN821CPCivil Air Patrol · Maxwell Afb, ALN821DHMilsap Charles M · Owensboro, KYN821HGGeorgia Aviation Authority · Eastman, GAN821SJc/Rc Ventures LLC · Key West, FLN821WTVest Michael S · South Beach, ORN821WWDouble Whiskey Flyers LLC · Highlands Ranch, CON8221VBorror Bryce C · Grants Pass, ORN8221ZHaralson Douglas K · Kenai, AKN8222MFrank Sherril P · Grapevine, TXN8223X23xray LLC · Houston, TXN8224MGreene Dennis M · Desert Hot Springs, CAN8224ZGloria Glenn Inc DBA · Roswell, NMFirst renewal noticeN8225HLout James M · Jasper, TXN8225MCarlson Farms Inc · Plentywood, MTN8225QCartoflight Inc · Willoughby, OHN82266Klondike International LLC · Lewes, DEN8227ZGa 27z LLC · Arlington, WAN8228MMurrin John A · Holbrook, MAN8229MOlsen Frances K · Bostwick, GAN822CSGottemoeller Aircraft Leasing Ltd · Fort Loramie, OHN822LMLehberger Charles W · Madison, CTN822RJJones Richard A · Naples, TXN8231ZChamberlain C Douglas · Bellefontaine, OHN8232ZWittber John R · Memphis, TNN8233MSixty Nine Kilo LLC · Oakland, CAN8233VHewitt Alan E · Federal Way, WAN8233ZLarky Brian L · Napa, CAN8236MCaptain Sky Helicopters LLC · Sahuarita, AZN8237MMiddle Tennessee State University · Murfreesboro, TNN8239ZWard James H Jr · Plymouth, NCN823BEStanley Joseph A Trustee · Thornville, OHN823CSRouch Timothy · Sturgis, MIN823LCBonafide LLC · Wilmington, DEN823SRLandmark Aerial LLC · Metuchen, NJN823TMMarther Thomas L · Albion, PAN8240ZSingleton Shermann S · Farmington, NMN8241MVenema-Ashmore Karin · East Dixfield, MEN8241VAlsworth Glen R · Port Alsworth, AKN8243MBundy Holdings LLC · Walnut Grove, MON8243ZHogscanfly LLC · Wagner, SDN8245MSea Seven LLC · Weatherford, TXN8245VFarnsworth James A · Sandy Valley, NVN8245ZByrum Scott L · Avondale, AZN8246ZChak Chak LLC · White Salmon, WA
Back to AD 84-10-01 R1