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.
N95231Duncan Paul D · Norfolk, NEN95236Plane Crazy LLC · Bennington, NEN95237Klassen Glenn Kurt · Chandler, AZN95238Date Greg · Spokane Valley, WAN9523DHauser Nathan S · Newark, DEN9523HVictor James A · Kingsville, OHN9523JMichalka James R · Portage, MIN9523LCnaa LLC · Mooresville, NCN9523UKpcw Grumman LLC · Port Clinton, OHN9523WOberg Harry W C III · Evanston, WYN95242Kane Aviation Holdings LLC · Bernardsville, NJN95244Banas Darryl P · Waco, TXN9524JZanella Paul J · Ballston Spa, NYN9524LHritz Michael G · Carlisle, PAN95253Mmou LLC · Fort Worth, TXN95255Herren Robert H · Lexington, KYN95259Erickson Landon S · Fairbanks, AKN9525DFlying Neutrons LLC · Lebanon, OHN9525JSandpiper Nag LLC · Louisville, KYN9525MVaughn Robert Bruce · Macon, GAN9525PGeorgetown Flying Club LLC · Pawleys Island, SCN9525TPorte Elvis · Miami, FLN9525UBaloo Flight Holdings LLC · Peoria, AZN95260Barr Air Patrol LLC · Mesquite, TXN95264Jorquez Andrew D · Santa Paula, CAN95265Red River Aviation Services LLC · Altus, OKN95266Walton Robert · Franklin Lakes, NJN9526BWildenberg Ronald · Beloit, WIN9526GAtlas Aviation Tampa Inc · Tampa, FLN9526HAbove The Haze LLC · San Lorenzo, CAN9526JWorthington Brian · Las Vegas, NVN9526LAnderson Jeffrey · Ann Arbor, MIN9526MRegistered aircraftN9526PSlenicka Kevin B · Enterprise, ALN9526UHart Lewis W DBA · Rexburg, IDN9526WMarch Theodore M · Fernley, NVN9526YBeechcraft Heritage Museum · Tullahoma, TNN95270Get Away 1 LLC · St George, UTN95271Ederer Martin J · Baraboo, WIN9527JOklahoma Flight Academy LLC · Owasso, OKN9527WDieck Michael J · Fayetteville, NCFirst renewal noticeN95285Bangerter James Alan · Indn Hbr Bch, FLN9528DGreenhead Flight Services LLC · Bemidji, MNN9528JGiles Dennis E II · Pearson, WIN9528URegistered aircraftN9528WWings Over Texas Holdings LLC · Denton, TXN9529DHeil Jay E · Brownton, MNN9529LMcdaniel Mark O · Martinsville, INN9529MWilson Judy · Stamps, ARN9529PCentral Air Parts Inc · Staunton, IL
Back to AD 81-18-04 R2