AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N7612WGunn Michael Reid · Wilson, ARN7613DHendrickson Aaron C · Mazomanie, WIN7613KSchramm Harold G · Utica, SDN7613PSimpson Randolph L · Shelburne Falls, MAN7613XCampbell Michael W · Fayetteville, TNN7614DBig Bend Community College Foundation · Moses Lake, WAN7614HCommand Aire LLC · Sitka, AKN7614JN7614j LLC · Berkeley Heights, NJN7614KGoering Rodney · Hutchinson, KSN7614RKull Phillip G · Monroe, MIN7614SNatural Pleasure LLC · Fayetteville, NCN7614VTucker Aviation LLC · Kalispell, MTN7614WFerris Lawrence D · Valentine, NEN7614YSky Walker Flight School LLC · Adrian, MIN7615GWashington Samuel C · Washington, DCN7615JAll American Aviation Services Inc · Fayetteville, NCN7615PFly High Ventures LLC · Chester, VAN7615WBittner Terry L · Woodbine, MDN7615ZRobinson Norman D II · Salt Lake City, UTN7616FBurgers Todd · Lagrange Hlds, ILN7616HDahmes Brad M · Hawick, MNN7616JThigpen Kevin · Jacksonville, FLN7616PNelson Peter T · Ghent, NYN7616RMalcom Brett W · Warner Robins, GAN76172Rjd Flight LLC · North Canton, OHN76177Brown Emily D · Niceville, FLN7617DRunyan Colton C · Ashland, ALN7617FKeldahl William J · Copperhill, TNN7617HGarcia Roberto P · Spring Hill, FLFirst renewal noticeN7617JMilner Quinn D · Carbondale, ILN7617PSlack Don S · Stinson Beach, CAN7617WWhirl'D Helicopters Inc · Sevierville, TNN7618KGrabousky Chad T · Halifax, PAN7618PJaton Bertrand F · Woodville, TXN7618SBraun Michael T · Oconomowoc, WIN7618WExaltium Aviation LLC · Baltimore, MDN7619FAinsworth Cavin · Fort Towson, OKN7619GMercer Aviators Inc · Princeton, WVN7619KNasby Kermit R · Shelbyville, INN7619PFirst Class Auto Remarketing LLC · Lehigh Acres, FLN761AZAndover Flight School Inc · Andover, NJN761CAChristiansen Aviation LLC · Wilmington, DEN761CCHesston College Aviation · Hesston, KSN761CSParker Todd Steward · Kaysville, UTN761DAKing Air 76 LLC · Lewes, DEN761ESCronsell Kenneth L · Hampshire, ILN761FGWilliams Glenn D · Columbus, GAN761GGChocks Away Aviaton LLC · Redmond, ORN761GSSaulsbury Greg F · Nash, TXN761LAIowa Lakes Community College · Estherville, IA
Back to AD 81-18-04 R2