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.
N8323YRochester Flying Club Inc · Rochester, NYN8323ZChapman Farms Inc · Vernon, CON8324Veal Tim S · Egegik, AKN8324EGc Aviation Services-1 LLC · Miamisburg, OHN8324PCirrus Air LLC · Eden, NCN8324TTango LLC · Chesterfield, MON8324USyren David N · Anchorage, AKN8324WSwofford Sherman A · Inman, SCN8324YStein Anthony J · Locust Grove, GAN8325EAnzaldi Carl J · Cherry Valley, CAN8325LLeading Edge Flight Services Inc · Hampshire, ILN8325RSy Aviation LLC · Judsonia, ARN8325TColumbia Jet Center Inc · Columbia, MON8325UCross Dustin · Tonto Basin, AZN8325VPct Hawk Inc · Wilmington, DEN8325WAircraft Guaranty Corp Trustee · Oklahoma City, OKN83268Wright Kim B · Bozeman, MTN8326CNewman Carl D · Phoenix, AZN8326ENorton Eric D · Nauvoo, ILN8326WBarnwell Sam M · Traverse City, MIN8326YEastern Stearman Inc Trustee · Leesburg, VAN83271Nohrenberg Raymond C · Pingree, NDN83272Bowker James D · Willow, AKN83275Perry Scott D · Hood River, ORN83278Hamlin Andrew J · Two Rivers, AKN8327LFill David · Hadley, MAN8327RWelsh Rick F · Ewing, VAN8327WFuture Flying LLC · Manassas, VAN8327YKaeser Robert E · Lafayette, INN83281Chandler Air Service Inc · Chandler, AZN83283Hayton James B · Sedro Woolley, WAN83285Dyches Abigail · Eagle River, AKN8328CSky Craft LLC · Powell, OHN8328LArrowhead Helicopter Services LLC · Jourdanton, TXN8328PSale Reported · Lewes, DESale reportedN8328UHale Larry D · Charlotte, NCN8328WTolmachev Nikolay A · Anchorage, AKN8328YSims Chris · Colleyville, TXN8329649 Ranch Co LLC · Odonnell, TXN83299Brewer Danny E Jr · Nikiski, AKN8329VBuck Timothy A · Howland, MEN8329YHarbock Inc · Wilmington, DEN832ABeck John Edward · Newton, IAN832AKOld City Helicopter Sales LLC · Saint Augustine, FLN832ATDot Aviation LLC · Wilmington, DEN832CPCivil Air Patrol · Maxwell Afb, ALN832EREmbry-Riddle Aeronautical University · Daytona Beach, FLN832KXHillsboro Aero Academy LLC · Hillsboro, ORN832MAState Of Wisconsin · Madison, WIN832RMMcbride Christen L · Elgin, TX
Back to AD 81-18-04 R2