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.
N6958VSale Reported · Austin, TXSale reportedN6958WPeck Michael S · Las Vegas, NVN6959PSteamboat Express LLC · Sheridan, WYN695APiper Archer Three LLC · Wilmington, DEN695ACHodgson Daniel J · Anchorage, AKN695APBuell Travis · Harper, TXN695CPCivil Air Patrol · Maxwell Afb, ALN695DTRegistered aircraftN695FParagon Flight Training Co · Fort Myers, FLN695FLPugh Daniel J · Omaha, NEN695LHJrnd Corp · Lewes, DEN695NDFly Gateway Aviation Institute · New Castle, DEN695PMSimonson Robert J · Cedar Crest, NMN695RAPhillips Robert M · Imperial, CAN695RDWerhanowicz Michael K · Hemet, CAN695SDDerek Dunn LLC · Levelland, TXN695SPJet Air Inc · Iowa City, IAN695XCloud 9 Aviation LLC · Bismarck, NDN6960HZiller Wayne Jr · Fairbury, ILN6960KTillman William L · Virginia Beach, VAN6960UWayne Brett M · Saint George, UTN6961BTrimmer Marvin E · Willow, AKN6961DOrtega David J · San Antonio, TXN6961QReed Billy B · Cabool, MON6961UMeservey Harley G · Portland, ORN6961VHunt David · Burlington, IAN6961WExpresstek LLC · Farmington, UTN6962JBores Scott J · Huron, OHN6962KBast William B · Fairbanks, AKN6962PSteyn Glen D · Marietta, OHN6962UGrey Scott A · Bluff City, TNN6962VRez Peter Trustee · Scottsdale, AZN6962WStalnaker Stanley A · Tifton, GAN6963DAbu Trailers Inc · Dwight, NDN6963JFly By Knight Inc · Hammond, LAN6963VBlough Lynn M · Pittsburgh, PAN6963WNash Larry A · Rockport, MAN69641Burke Jason C · Juneau, AKN6964HMor Aviation N6964h LLC · Gaithersburg, MDN6964PEvans Phillip R · Dinuba, CAN6964QSliger Arbie D · Benton, KSN6964ULara Anthony · Manitou Springs, CON6964VDavis Thomas Leigh · Carrollton, TXN6964WKuss John D · Webster, NYN6965DFondy Victor L · Whitewood, SDN6965JDanik LLC · Harper Woods, MIN6965PBoucher Bobbi · Fredericksburg, VAN6965WSitaras Evangelos · Ladonia, TXN6966CSchlichter Timothy J · Huntsville, ALN6966JTwo Mile Final LLC · Spring, TX
Back to AD 81-18-04 R2