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.
N7499WWoodward Adam B · Fort Collins, CON749CCOtto David L · Lacey, WAN749CSBower John M · Santa Cruz, CAN749DMPreferred Metalfab Inc · Mora, MNN749DWAntler Aviation And Wildlife Service LLC · Wasilla, AKN749JFFrazee John F · Fabius, NYN749MCWilliams Rodger Gale · Broseley, MON749PASkywest Leasing Inc · St George, UTN749PCGreen Hornet Aviation LLC · Washington, DCN749PJAgl Aviation And Management LLC · Payson, AZN749REWheatley John P Jr · Thorp, WAN749SKOcean Aerial Ads Inc · Berlin, MDN749TFNavmar Applied Sciences Corp · Ivyland, PAN749TMKeithley Thomas E · Pueblo, CON749TWTumbleweed Leasing Co Inc · Salt Lake City, UTN749VWGenet David S · Saint Augustine, FLN74ABAerial Digital Images LLC · Huntington Beach, CAN74ALDavis Tessie · Buckeye, AZN74ATGelvin Stanley M · Central, AKN74BFSellers Jim M · Watkinsville, GAN74BGReliance Aviation LLC · Mendon, NYN74BMAlexander City Aviation Corp · Alexander City, ALN74BNBig Bend Community College Foundation · Moses La, WAN74CPersonal Aviation Inc · Poway, CAN74CDMcburney & Associates LLC · Horseshoe Bay, TXN74CNBuckley Scott · Orcutt, CAN74DBSanderson Bryan D · Eagle, IDN74DCCoburn Toni · New York, NYN74DJWood Shawn A · Cassville, WIN74DMT C Rian Association LLC · Grove, OKN74DNMooney Daniel P · Edmond, OKN74DPRegistered aircraftN74DVRegistered aircraftN74EKFaires Thomas F Jr · Lake Providence, LAN74EPCantrell Grady DBA · Los Banos, CAN74ERSimplifly LLC · Mesa, AZN74FAMangelsdorf David M · Raton, NMN74FCParry Mark W · Homestead, FLN74FFFf22 LLC · Scottsdale, AZN74FPPettit Myron F · Mesa, AZN74GMMellen George J · Powell, OHFirst renewal noticeN74GNStuckey Connections LLC · Magnolia, TXN74HPRoberts Joseph F · Bell Buckle, TNN74HYRegistration Pending · Roundup, MTRegistration pendingN74JDMazza Joseph D · Queensbury, NYN74JFHager Bill E · Parma, IDN74JJWard Ralph G · Parrish, FLN74JPGulf Coast Helicopters Inc · Pearland, TXN74KDDannenberg Kenneth H · Holland, MIN74KKKrauser Kent F · Lake Mary, FL
Back to AD 81-18-04 R2