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.
N80251Harrison Social Flites Inc · Harrison, OHN80254On Glideslope LLC · Middletown, DEFirst renewal noticeN8025CLaabs Fran C · Ames, IAN8025EMission Aviation Fellowship · Nampa, IDN8025GN8025g C177rg LLC · Jeffersonville, INN8025N8025n Flyers Ltd · Monsey, NYN8025RGaboury Michael J · Two Harbors, MNN8025WMann Nicholas Lee · Grand Canyon, AZN8025XCivil Aviation Leasing Ltd · Wilmington, DEN80263Breton Yacht Co LLC · Schenectady, NYN80267Bisson James H · Piercefield, NYN8026CWyatt Gaylon J · Pineville, ARN8026NJenkins Carl S · Muncy, PAN8026PMontgomery Investments Inc · Washington, UTN8026QInternational Fun Place Hangar 32 LLC · Laughlin, NVN8026YCaillouet Andre E Jr · Houma, LAN80270Fisher Robert · Shoreacres, TXN80277Usaeroflight LLC · Greenville, SCN80278Baur Ronald N · Gig Harbor, WAN80279Tueller John D · Spring Creek, NVN8027FCyganski David · Palm Beach Gardens, FLN8027GBas Part Sales LLC · Greeley, CON8027YGreek Housing Services Corp · Port Matilda, PAN80282Nguyen Nhu-An T · Bethesda, MDN80283Barxbar Aviation LLC · Mesa, AZN80287Campbell Frederick G · Rigby, IDN8028CLisk Justin T · Rhodes, IAN8028GAndersen Timothy R · Elizabeth City, NCN8028RBorgers Thomas R · Palmyra, NJN8029Sorenson Tyler D · Bountiful, UTN80291Davidson Doug W · Newcastle, WAN80295Legacy Skies Aviation LLC · Rogers, ARN80298N80298 LLC · Miami, FLN80299Mountain Air Aviation Inc · Bethesda, MDN8029CFlying Zoo LLC · Collinston, UTN8029GIndy Air Sales LLC · Anderson, INN8029MDixon Kenneth P · Arvada, CON8029NHeydenreich Jacob N · Hartford, ARN8029PLong Trevor J · Flower Mound, TXN802ATFlight School Of Texas LLC · Wilmington, DEN802CMN802cm LLC · Lebanon, MON802CPCivil Air Patrol · Maxwell Afb, ALN802DDN802dd Corp Trustee · Wilmington, DEN802DPGross Robert M · York, MEN802ERValiair Lc Trustee · Casper, WYN802FGRidgeline Assets LLC · Wilmington, DEN802FSShelton Shannon · Hampton, GAN802KSKansas State University · Salina, KSN802NMFlight Operations Aircraft LLC · Wilmington, DEN802PWFlying Mermaid LLC · Aiea, HI
Back to AD 81-18-04 R2