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.
N7441YHatton Leslie A · Chesapeake, VAN74426Spitzer Helicopter LLC · Woodland Hills, CAN74429Xinther LLC · Belle Mead, NJN7442KLipper Stephen W · Griffin, GAN7442PBalske Curt A · Bedford, TXN7442SLawrence Stanley D · Sacramento, CAN7442WDenney David L · Oak Grove, ORN7442YMy Toys Inc · Jacksonville, FLN74434Lyet J Paul · Lititz, PAN74435Sutton Aircraft Salvage LLC · Palmer, AKN74438Pearl Jonathan D · Ocean City, MDN74439Costanza Frank V · Picayune, MSN7443JPiper Aero Adventure LLC · Port Orange, FLN7443RClarkson Brett D · Stuarts Draft, VAN74442International Air Services Inc Trustee · Carson City, NVN74447South Texas Aviation Group Inc · Helotes, TXN7444DRups Adventure North LLC · Arbor Vitae, WIN7444RMarchionda Bruce · Sherman, TXN7444WMedia Stew LLC · Carson City, NVN74451Continuous Improvement Solutions Llp · Bella Vista, ARN74452Delmarva Skies LLC · Milton, DEN74453Wientjes Randy R · Metropolis, ILN74458Flying Tiger P40 LLC · Healdsburg, CAN7445JNosal Ivan · Itasca, ILN7445PN7445p Flying Club LLC · Union City, CAN7445WArola Anthony L · Tacoma, WAN7445YCherish Aviation LLC · Woodbridge, VAN74465Clarabut Alexander · Santa Clara, CAN7446DNeufeld Bernie T · Dalhart, TXN7446FAir Sprayers Inc · Two Buttes, CON7446JLkn Aviation LLC · Cornelius, NCFirst renewal noticeN7446REckert Travis R · Texarkana, TXN7446YN7446y Aero LLC · Joplin, MON74470Barbeau Timothy A · Saint Peters, MON74472Willis John B · Katy, TXN74478Sato Steven S · Green Bay, WIN7447JWiley Calvin · Summer Shade, KYN7447KNiemyjski Justin S · Franksville, WIN7447NJc Flight Inc · Wilmington, DEN7447RCompo John · Essex Junction, VTN7447VBaca Robert A Trustee · Auburn, CAN74481Holley Jack · Morehead, KYN7448PBurshem Ben E · Bay City, WIN7448RCraddock Ellis G · Colorado Springs, CON7448WBoyce Gillis · Savannah, TNN74499Dawn Wolf Technologies Inc · Wichita, KSN7449GAvmajic LLC · Waterford, MIN7449KBuehler Andrew · Eatonville, WAN7449PAshcroft James K · Hurricane, UTN7449WMutch Robert E · Barrington, NH
Back to AD 81-18-04 R2