AD 84-10-01 R1
Registered aircraft · 20,483
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.
N3542UChristensen Paul · Granite Falls, WAN3542YNash Richard P · Missoula, MTN3543FKorngold Brandon L · Aliso Viejo, CAN3543HMagness Thomas W · West Chester, PAN35443Registered aircraftN3544FFercho Corliss Y · Glendive, MTN3544UKarmik Aviation LLC · Fort Edward, NYN3544YPeters Ben · Seminole, TXN3545JBarr Air Patrol LLC · Mesquite, TXN3546FN3546f LLC · Kitty Hawk, NCN3546HOdonnell John Merritt · Kennebunkport, MEN3547UPanhandle Aviation LLC · Thatcher, AZN3547YS & W Aviation LLC · Saint Peters, MON3548MSpenser Air LLC · Starkville, MSN3548SSunny Skies Aviators LLC · Vernal, UTN35498Ray Arthur G · Springdale, ARN3549UKimble Bryant Shane · Hinton, OKN3549YTimuuu Inc · Alden, NYN354BSStevenson Bill · Sunrise Beach, TXN354CPCivil Air Patrol · Montgomery, ALN354STelfer William D · Perkasie, PAN3550FYoung Tom · Alton, MON3550UYoung Mary J D · Waynesville, OHN3550YForman Barnes LLC · Nampa, IDN3551FBursley Richard R · Phoenix, AZN3551UFallini Anna M · Tonopah, NVN3551YWethered Dvm LLC · Boise, IDN3552DBarwick H Brooks III · Clinton, NCN3552FAirplanes Over Niagara LLC · Lewiston, NYN3552L4wblue LLC · Waccabuc, NYN3552QRegistered aircraftN3553YMiller Jaime W · Deer Park, NYN3555FStern Andrew · New York, NYN3556VWestbank Fishing LLC · Kiln, MSN3556YLodestar Aviation LLC · Mooresville, NCN3558YRegistered aircraftN3559EGreater Flint Pilots Association Inc · Flushing, MIN3559RWest Indies Aviation Corp Trustee · Wilmington, DEN355CPCivil Air Patrol · Maxwell Afb, ALN355GMTextron Aviation Inc · Wichita, KSN355STScootair LLC · Alburgh, VTN355TAIsland Amphibs LLC · Fort Lauderdale, FLFirst renewal noticeN355YPlussa Mark George · Clermont, FLN3560FAdams Chris · Braselton, GAN3560UMcmaster John F · Wichita, KSN3560XCarey Brad Eugene · Grapeview, WAN3560YTriple J&M Flying LLC · Guymon, OKN3561YDk Futures LLC · Reno, NVN3562FHexd Medical · Rexburg, IDN3562UPrairie Aviation Of Hamilton Inc · Corvallis, MT
Back to AD 84-10-01 R1