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.
N587BHitterman James D · Metropolis, ILN587KAtp Aircraft 3 LLC · Wilmington, DEN587KBSwihart Painting LLC · Bolivar, MON587MALong Island Aviators LLC · Seaford, NYN587PAVan Hatten Michael Sr · Fairbanks, AKN587SPPinnacle Aviation Services Inc · Encinitas, CAN587TPPockrus Pat B · Mineral Wells, TXN587WPLindner James F · Williamsburg, MIN5880ENashville Skyscrapers LLC · Old Hickory, TNN5880QSeely Scott · Edmond, OKN5880WDurkin Michael T · Sunland, CAN5881DKanooth Michael L · Washougal, WAN5881HGazda Jerry V · Granbury, TXN5881URegistered aircraftN5882FGo Fly Mi LLC · Saginaw, MIN5882LBreazeale Peter · Orangeburg, SCN5882PEvans Gene · Henderson, TXN5882QBean Merton H III · Phoenix, AZN5882UMartinez Guillermo E · Upland, CAN5883LOst Kenneth Alan · Langhorne, PAN5883QSnyder Stephen L · Lebanon, TNN5883ZMckernan Thomas H · Gabriels, NYN5884DMcmahan Johnny W · Gakona, AKN5884QOasis Aero Inc · Willmar, MNN5884UB & R Aircraft LLC · Wadsworth, OHN5885DConatser Shawn C · Fairbanks, AKN5885PCostanzo Christopher P · Staten Island, NYN5885ZLewis Vincent E · Oregon, MON5886DAg Solutions Of West Texas LLC · Roby, TXN5886FBacktoeden LLC · Casper, WYN5886H86h LLC · Burlington, VTN5886LCook Charles N · Lakeside, TXN5886PAce Aeromotive Inc · Miami, FLN5886XPeak Investments LLC · Roanoke, VAN5886ZArgabright Jeremy E · Bloomfield, MTN5887DBragdon James O · Monticello, FLN5887NBerkshire Commander Air LLC · Pittsfield, MAN5887UFretz Richard G · Harrisburg, PAN5888HGfeller Kent · Winona, KSN5888PRegistered aircraftN5888QCross The Line Sales Inc · Lexington, NCN5888ULynch Francis X · Dumont, NJN5888ZGoldberg David C · Garner, NCN5889L100 Rads Corporation · Omaha, NEN5889RPatkotak Crawford A · Barrow, AKN5889VRegistration Pending · Cherry Hill, NJRegistration pendingN5889WHarrison Joshua · Canyon Country, CAN588AVAir Ventures Hawaii LLC · Lihue, HIN588BCSamela Nicholas V · Thomaston, CTN588CPTjomsland Bryan · Culver City, CA
Back to AD 81-18-04 R2