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.
N8684DScott Lonnie L · Nikiski, AKN8684EMotl Gregory C · Humble, TXN8684WFleming Joanne M · Davenport, WAN86854Moore Planting Co Inc · Cary, MSN86863Pruitt Leland L · Jones, LAN8686WSchwalbach Nicholas J · Saint Paul, MNN8686YAdvanced Aviation LLC · Midlothian, VAN86872Chupito Sabrocito LLC · Paso Robles, CAN86879Knik Flying Club LLC · Anchorage, AKN8687CMorgigno Daniel A · Mission Viejo, CAN8687VCollum Aviation LLC · Milton, FLN8687WJaques Wayne R · North Little Rock, ARN86883High Exposure Inc · Wilmington, DEN86885Mason Peter Trustee · Santa Paula, CAN8688DHarmon Mike D · Mansfield, SDN8688VHawkeye Aviation LLC · Newport, ARN8688WCameron Vincent A · Menifee, CAN8688YMager Robert R · Quakertown, PAN86890E-Commerce Education Foundation · Tulsa, OKN86892Goodman Jack · Memphis, TNN8689VZacheis Henry M · Fairbanks, AKN8689YBlue Sky Aviators LLC · Winnebago, ILN868BBahrns Phyllis Alyene · Effingham, ILN868JDBratton Charles M · Gatesville, TXN868KWeber Jennifer R · Bryan, TXN868KFSmith Jason · Calliham, TXN868LHJones Aircraft Co LLC · Cross Plains, TNN868MMUhl Gregory R · Columbus, MSN868PProfessional Training Aircraft LLC · Wilmington, DEN868PKYellow Therapy LLC · Kalispell, MTN868RTMartin John D · Billings, MTN868SAS O W Aviation LLC · Crystal River, FLN868SPWestbank Fishing LLC · Kiln, MSN868TBSo Cal Leasing LLC · El Cajon, CAN868UInter American University Of Puerto Rico · Bayamon, PRN868XGuhr Robert · Stockholm, NJN86901Rudderow Preston Trustee · Anchorage, AKN86911Schneberger Bart A · Nome, AKN86919Latham Ray H · Raymond, WAN8691COrtet Craig A · Etna, WYN8691VAviation Specialists LLC · Wilmington, DEN8691YVan Bladeren John A · Tigard, ORN86928Collum Aviation LLC · Milton, FLN8692CTexas Air And Space Museum Inc · Amarillo, TXN8692DBryan Kirk J · Big Timber, MTN8692VLohr Martin J · Petersburg, AKN8692YTedder Ag Technologies Inc · Walsh, CON86936Lewis Aviation Inc · Wilmington, DEN8693VMichael A Levenhagen · North Fort Myers, FLN8693WPack Timothy W · Blacklick, OH
Back to AD 81-18-04 R2