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.
N61663Mohamed Eman Z · Lubbock, TXN6166DClb LLC · Boerne, TXN6166JBorder Steven C · Wharton, TXN6166MBradley Aero Services Inc · Southwick, MAN61670Registered aircraftN61671Charlotte Flyers Inc · Fort Myers, FLN61672American Patrols Inc · Midland, TXN61676Vectors LLC · Sterling, VAN61677Morcom Aviation Services Inc DBA · Everett, WAN6167KDuncan Marianna G · Lufkin, TXN6167LEastern Cincinnati Aviation Inc · Batavia, OHN6167PRico Nathaniel J · Astoria, ORN6167SHeaberlin Henry L · Corbin, KYN61680Kaye Linda · Grove, OKN61683Migdalski Randall C · Pembroke Pines, FLN61684Odyssey Aircraft LLC · Topeka, KSN61687Advanced Rehab Specialties Pa · Leesburg, FLN61689Bc 414 LLC · Los Angeles, CAN6168DMadison James E · Concord, CAN6168SFerrell William W II · Flagstaff, AZN6168VYoung Martin H II · Rogers, ARN6168WSchwenning Donald R · Upper Sundusky, OHN6168XKey Daemon S · Lexington, TNN6168YIngalls Donald H · Morgan Hill, CAN61692Pittsburgh Institute Of Aeronautics · West Mifflin, PAN61694Scholz Mark W · Atchison, KSN61696Bakker Margaret E Trustee · Petaluma, CAN61697L&W Aircraft Investment LLC · Homestead, FLN61699Erickson Steve · St Michael, MNN6169PKlier John M · Alpine, CAN6169RN999gk LLC · Nantucket, MAN616AMartin Andrew D · Odessa, FLN616AADowns Kenneth · Houston, TXN616ACN616ac LLC · Westfield, MAN616ADArcher Aircraft LLC · Wilmington, DEN616AGWjk3 Aviation LLC · Savannah, GAN616AMMusson Brian D · Camas, WAN616AVSouthern Aviation Ga LLC · Anchorage, AKFirst renewal noticeN616AWAtd Pilot Training Lllc · Kansas City, MON616CGPeterson Colin C · Plano, TXN616CPTextron Aviation Inc · Wichita, KSN616DMMoorman Jesse David · Centerville, IAN616ESDiamond Larry Michael · Galax, VAN616FKenzy 2020 LLC · Aurora, ORN616FLFlight Gear Aviation LLC · Pickerington, OHN616HTWright S A Trustee · Cave Creek, AZN616KCN616kc LLC · Conway, ARN616LMThurman Mark · Farmington, MON616LYPanzer Jessica DBA · Lincoln, NEN616MCFletcher Flying LLC · Russellville, AR
Back to AD 81-18-04 R2