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.
N6611DMoralli Joseph · Chico, CAN6611PSelect Charities LLC · Spokane, WAN6611UVan Koevering Dennis Jay · Hudsonville, MIN6611WBryant Bryce Nicholas · Crothersville, INN6612LSwanson Thomas J · Pukwana, SDN6612RCourtney David P · Reedsport, ORN6612UGiem James L · Coupeville, WAN6612VEverman Terry Jay · Vassar, MIN6613H6613 H Ltd · Wilmington, DEN6613RPollazzi Steven N · New Hope, PAN6613WBanks Jeffrey G · Columbus, OHN6614UVanderford Kenneth W · Fort Worth, TXN6614VThomas Anna D · Kiana, AKN6615DCivil Air Patrol Inc · Montgomery, ALN6615JAeropenn Aviation Academy LLC · Paxinos, PAN6615NTexas Skyways Research & Development · Boerne, TXN6615UDobos Lester J · Bordentown, NJN6615WLoughridge Steven L · Montezuma, OHN66168C P Aviation · Santa Paula, CAN6616DMjng Investment Group LLC · Melbourne, FLN6616HBurke Anthony · Poughkeepsie, NYN6616JBrack Enterprises LLC · Indianapolis, INN6616PMorrison Austin · Statesville, NCN6616RVanover Kevin · Whitesburg, KYN6617ELinstad Daniel Elmer · Canby, ORN6617HNorth Franklin County Flying Club · North Lawrence, NYN6617JJeffries Holdings LLC · Bargersville, INN66189Skynick Enterprises Inc · Tarzana, CAN6618DStein Air LLC · New Ringgold, PAN6618PChurchill John C · Parker, AZN6618VLang Gerald K · Baker, MTN6618WLe Ariya · La Crosse, WIN6618ZRotor And Wing · Tioga, NDN6619DBannwart Justin S · North Liberty, INN6619JBjelland Nathan D · Phoenix, AZN6619PRatliff Byron L · Paragould, ARN6619ULucas Jolie Candace · Pismo Beach, CAN661CCMarkey John J Jr · Aurora, ILN661CPSouthern Aircraft Consultnacy Inc Trustee · Casper, WYN661DJRadley Larry L · Universal City, TXN661EREmbry Riddle Aeronautical University Inc · Prescott, AZN661FLS B Enterprise LLC · Marshall, TXN661FTFlorida Institute Of Technology Inc · Melbourne, FLN661HPMotorcarlease USA Inc · Miami Beach, FLN661JCKruse Thomas S · Mena, ARN661JPEvans Craig A · Irvine, CAN661JSStrausbaugh Joseph A · Dublin, OHN661KFurrow Terry · Hinton, OKN661KKSouthern Aircraft Consultancy Inc Trustee · Casper, WYN661MTMiddle Tennessee State University · Murfreesboro, TN
Back to AD 81-18-04 R2