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.
N606STStruck Jeffrey · Orange City, FLN606TTTotusek Torger · La Palma, CAN606UAlba Leasing Services LLC · Scottsdale, AZN606WLarson Bernard J · Mt Vernon, WAN6070CShepard Gregory W · Fort Myers, FLN6070LPloski Greg · Prospect, CTFirst renewal noticeN6070NKnott Donnie W · Milan, TNN6070PParcell Charles W · La Canada Flt, CAN6070QOdenbach Eric J · Eureka, SDN6070WHocking Christopher J · Hinckley, MNN60717Southern Comfort Horizons LLC · Naples, FLN6071DRiffle Thane G · Addy, WAN6071NJames Selle Aviation LLC · Bonesteel, SDN6071PKohler Thomas M · Brant Beach, NJN6071QHaven Hospitatlity LLC · San Marino, CAN6071WAbbott Joseph D · Chippewa Falls, WIN60728Valiair Limited Company Trustee · Casper, WYN6072LLawrence Blake C · Monument, ORN6072NDilecce Joseph · Sarasota, FLN6072QTorres Mendoza Gonzalo · Rancho Cucamonga, CAN6072WHillman Maritime Services LLC · Lafayette, LAN60733Rentner Judith E · Bigfork, MTN6073AIjet LLC · Clarence Center, NYN6073DDetrick Louis F · Eighty Four, PAN6073LKottke Benjamin P · Central Point, ORN6073NRozinka Jay C · River Falls, WIN6073PBradshaw James L · Lenoir, NCN6074FFly America Inc · Palo Alto, CAN6074NParlog Roy H · Irwin, PAN6074PBerlingen Michael W · Oregon City, ORN6074QMiranda Edward G · Prescott Valley, AZN6074VBabb Bradley E · Enid, OKN6074WRegistration Pending · Los Angeles, CARegistration pendingN6075LChandler Air Service Inc · Chandler, AZN6075PMoore Leslie D · Raymore, MON6075VLister Cameron M · Loxley, ALN6075WVolk Alyssa M · Jordan, MNN6075ZModular Aviation LLC · Saratoga Springs, UTN6076DPinnow Andrew W · Cheshire, CTN6076GColbert Farms Inc · Davenport, WAN6076MRomano Victor J Jr · Wasilla, AKN6076WBlyseth Brent A · Germantown, TNN6077DPargman Curtis A · Big Lake, MNN6077EAir Fleet Holdings LLC · Addison, TXN6077NKrig Marie · Seattle, WAN6077TStout Joel D DBA · New Cumberland, PAN6077WParrish Stephen W · Minneola, FLN6077YGreenair Corp · Memphis, TNN6078CKtoa Rentals LLC · Torrance, CAN6078DWagar Dennis Murphy · Marion, MT
Back to AD 81-18-04 R2