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.
N8384HTwin Tier Aviation Association Inc · Eldred, PAN8384PMauch Archie C · Magnolia, TXN8384SBuschmeier William A · Cincinnati, OHN8384WWilt Jared C · Marysville, OHN8384YProgressive Flying Corp · North Salem, INN8385LKrebs Lisa Christine · Homer, AKN8385QBlue Sky Harbors LLC · Crystal, MNN8385SN8385s LLC · Lancaster, PAN8385WJohnson Robert J · Floral City, FLN8385YNesbitt Loyd B Jr · Independence, ORN8386BSprj Aviation LLC · Tampa, FLN8386C86 Charlie LLC · Rochester, MNN8386LAdams Haidyn · Pentwater, MIN8387CRuday Dennis J DBA · Glendora, CAN8387JCallison Patrick L · Hazel Green, ALN8387LSerra Christopher R · Snellville, GAN8387RMiloud Chadd K · Fort Worth, TXN8387VN8387v LLC · Lansing, MIN8387WHolt Zachary Ian · Bogalusa, LAN8387YN8387y LLC · Huntsville, ALN83882Warrior 83882 LLC · Dover, DEN8388AHamm Simon P · Denali, AKN8388RFloyd James · Gainesville, TXN8388WWatts Timothy S · Denver, NCN8388YInternational Air Services Inc Trustee · Carson City, NVN83896Clifford Aviation LLC · Delta, CON8389AJacobus Larry E · Ipava, ILN8389EBymers Robert F · Waunakee, WIN8389LJkg LLC · Murfreesboro, TNN8389PPower Joe D · Seguin, TXN8389VNelzen Wayne K · Mulino, ORN8389WStegemoller Ronald G · Washington, TXN838AJsl Air LLC · Sikeston, MON838BCN838bc LLC · Naperville, ILN838CFCherokee Flyers Inc · Vero Beach, FLN838DHGcbc LLC · Norman, OKN838EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLN838JHFitzmaurice Doyle · Sparta, WIN838JWFleming Cheri Rene · Joseph, ORN838KSKansas State University · Salina, KSN838MACca Aero Estate LLC · Missoula, MTN838MBFreischlag Karl A · Fort Collins, CON838MMZhang Li · Palo Alto, CAN838MPWhitney Stephen · Fort Myers, FLN838PProfessional Training Aircraft LLC · Wilmington, DEN838PCGadamic LLC · Fresno, CAN838SShaw James J · Loranger, LAN838SPEdb Air Inc · Wilsonville, ORN838TStandard Jacob R · Lakeway, TXN8390CArserio Gregory J · Fairport, NY
Back to AD 81-18-04 R2