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.
N61808Cape Island Aviation LLC · Millville, NJN6180LAryvue Inc · Cordele, GAN6180TInternational Air Services Inc Trustee · Carson City, NVN6180WChristiansen Aviation LLC · Wilmington, DEN6180XLewis University · Romeoville, ILN6180ZZeliff Aviation LLC · Batavia, NYN61812Craft Robert L · Cynthiana, KYN61813Nationwide Aviation LLC · Hudson Oak, TXN61814On Glideslope LLC · Middletown, DEN61817Rb Aviation LLC · Vassar, MIN6181DNolta Christopher D · Corcoran, CAN6181FTarchinski James E · Rochester Hills, MIN6181PLowe David M · Sacramento, KYN6181RTrahan Gregory M · Rayne, LAN6181TFree Theta Aeronauctics LLC · Sacramento, CAN61822Wings Over Texas Holdings LLC · Denton, TXN61825Prestage Michael J · Hondo, TXN6182DGr8daynevada LLC · Carson City, NVN6182FAllsouth Aviation LLC · Buford, GAN6182LHansen Karl G · Waxahachie, TXN6182UEfi Aviation LLC · Wilmington, DEN6182WBarrette Jason W · Mandeville, LAN6183Golden Age Air Museum · Bethel, PAN61832Prop Wash Aero Inc · Senoia, GAN61834Offerman Leo · Emily, MNN61835Epic Aviation Leasing LLC · Puyallup, WAN61837Park Richard J · Devol, OKN61839Fixen Jimmie Trustee · Lynd, MNN6183LPittsburgh Institute Of Aeronautics · West Mifflin, PAN6183SFarm Air LLC · Gridley, CAN6183VCripe Rodney J · Middlebury, INN6183WMartin Neal O · Reno, NVN6183XCanipe Kendall L · Shelby, NCN61840Jimenez Cruz Juan C · Mayaguez, PRN61841Burggraf Sean Hj · Grand Rapids, MNN61842Skywalker Flight Schoool LLC · Adrian, MIN6184JInverted Holdings LLC · Newnan, GAN6184PCollins Michael J · Chandler, AZN61852Knight-Graham Michael L Trustee · Truckee, CAN61856Paraclete Sky Adventures LLC · Raeford, NCN61859Jprg Aviation Inc · Orlando, FLN6185DOmega 1 Corp · Middletown, DEN6185HSargent Patrick S · Bicknell, INN6185JYankee Pilots Inc · Haverhill, MAN6185RSkywalker Ranch LLC · Dover, DEN6185UMustang Sally Aviation LLC · Camden, SCN61866Wings Over Texas Holdings LLC · Denton, TXN61868Jamm Aircraft LLC · Sterling, OHN6186JRegistration Pending · Sebastian, FLRegistration pendingN6186TAtlas Aviation Tampa Inc · Tampa, FL
Back to AD 81-18-04 R2