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.
N7627NRanger Aviation Inc · Burlington, CON7627PKill Stephen W · Granbury, TXN7627RReising Douglas C · Caseyville, ILN7627SJohnson Richard M · Osceola, WIN7628KKrompacky Jozeph E · Talkeetna, AKN7628LAerial Serveys Inc · Post Falls, IDN7628RWilson Rodney C · Flagstaff, AZN7628YLamantia Mark V · Ebensburg, PAN7629GDodd Dennis R · Collinsville, OKN7629JWatson Tony A · Rydal, GAN7629KLudwick Jacob W · Dunkirk, INN7629WMah Michael · Pittsfield, MAN762ALrh Equipment LLC · Pendleton, ORN762ABPlane And Simple Leasing LLC · Delano, MNN762ADKahle James H · Morristown, NJN762AFLake Area Technical Institute · Watertown, SDN762AHHamad Aneese A · Cortland, OHN762AMTippit Larry J · Arlington, TXN762BGBrumbaugh Aviation LLC · Lewes, DEN762BHViglierchio David R II · Davis, CAN762BMMarshall Baron R · Marion, MTN762CMAnderson Daniel S · Payson, AZN762CPCivil Air Patrol · Maxwell Afb, ALN762DHGo Mango LLC · Las Vegas, NVN762DRC & J Flying LLC · Rapid City, SDN762JRRohauer James D · Attica, NYN762JSSayers James B · Edison, OHN762JTPurdue University · West Lafayette, INN762KEGrasley Steven S · Green Cove Springs, FLN762KGDickens Randy L · Fuquay Varina, NCN762MMGraham Jimmy E · Morristown, AZN762NDUnd Aerospace Foundation · Grand Forks, NDN762PJTalcott James · Sutton, AKN762PSAlpine Veterinary Service Inc · Billings, MTFirst renewal noticeN762SMMyers Shawn Lee · Rincon, GAN762SSShetter Steven P · Chambersburg, PAN762SUAlmost There Air LLC · Daytona Beach, FLN762TRWood Eugene H · Hickory, NCN7630HRubbert Jan D · Upham, NDN7630SKidd Alan E Trustee · Louisburg, KSN7630YJprg Aviation Inc · Orlando, FLN7631FMatthew E Richards · Southaven, MSN7631GChickadee Aviation LLC · Rangeley, MEN7631HSeibold Bryan S · Big Lake, AKN7631TBoyd James J · Alexander, NCN7631WDyer Troy · Wolcottville, INN7631YMbsp Enterprises Inc · Wilmington, DEN7632FFlymart Inc · Hastings, FLN7632HAndersen Dana K · Scappoose, ORN7632SLocker Don D · Muleshoe, TX
Back to AD 81-18-04 R2