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.
N7742JAirmore Inc · Gainesville, FLN7742KHanson Rustin W · Spokane, WAN7742MGribble Ted · Paris, TXN7742NDistler Robert · Northborough, MAN7742WDupont Micheal Rene · East Taunton, MAN7743DHann James M · Ballwin, MON7743HDavis Lawrence J · Wasilla, AKN7743MPatry Aeronautical Institute · Kalispell, MTN7743NRegistered aircraftN7743PWelch Brandon D · Liberty Hill, TXN7743WAtigun Aviation LLC · Sheridan, WYN7743YSchroeder David C · Norfolk, NEN7744HCreglow Jacob A · Anchorage, AKN7744KOhlau Mark A · Wellington, NVN7744MMike Clark Trucking Inc · Colton, CAN7744SVista Air Inc · Pacoima, CAN7744TDickert Investments Holdings LLC · Cave Creek, AZN7744WShotwell Michael · Dallas, GAN7744YCossette Aircraft LLC · Laporte, MNN7745DSale Reported · Joseph, ORSale reportedN7745GSuperhawk N7745g Owners' Group LLC · Bend, ORN7745KDe Vecchi Guiancarlo Sergio · Montague, NJN7745MGsh Of Alabama LLC · Huntsville, ALN7745NAppealing Adventures Inc · Canadensis, PAN7745PFleming James D · Alamosa, CON7745WSchaff Investments LLC · Stone Mountain, GAN7746BMartin Gavin R · Los Angeles, CAN7746DDobson Garland J · Willow, AKN7746FWilliams Dwight J · Wichita, KSN7746KBuergel Sandra J · East Aurora, NYN7746PFlip Flops & Flight Plans LLC · Saint Petersburg, FLN7746YSnow Robert I · New Caney, TXN7747GKelley Aircraft LLC · Weyers Cave, VAN7747NShumock Jerry Ray · Moss Point, MSN7747PBartley John H · Vassalboro, MEN7747WFlying Family LLC · Orlando, FLN7747YBohannon Philip Wayne · Houston, TXN7748DJagust William M · Troy, MON7748HTurnbull Douglas M · Bloomfield, NYN7748JBas Part Sales LLC · Greeley, CON7748MLarson David · Klamath Falls, ORN7748PCardiovascular Service Associates · Downers Grove, ILN7749DOakley Lance E · Conway, ARN7749FLohr Martin J · Petersburg, AKN7749JKokomo Aviation Inc · Boynton Beach, FLN7749NTeijeiro Edgar E Trustee · El Paso, TXN7749TTurner Tim R · San Angelo, TXN774ACDarr Henry H · Drummond, MTN774CAChristiansen Aviation LLC · Wilmington, DEN774CFApperson Aviation LLC · Palm City, FL
Back to AD 81-18-04 R2