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.
N98923Costa Flying Service Inc · Painted Post, NYN98927Deleon Joseph M · Saint Petersburg, FLFirst renewal noticeN9892GFritz John P · Belvidere, NJN9892PArizona Soaring Inc · Maricopa, AZN9892QLytle Jack J · Omaha, NEN9892YWraith Daniel T · Wasilla, AKN98932Podeweltz Wayne Leo · Merrill, WIN98935Meketa George C · La Vernia, TXN9893LStansfield Tod A · Elm Grove, WIN9893QDougherty Casey · Rock Island, WAN9893WSky High Aviation LLC · Streamwood, ILN98941Flaglor Thomas R · Mosheim, TNN98944Phelps Douglas E · Salem, ORN9894G1s6 Flying Club Inc · Sandpoint, IDN9894LHilton Allen J A Jr · Justin, TXN9894QKarpov Konstantin A Trustee · Fort Bragg, CAN98954Emerson Solutions LLC · Bellingham, WAN98959Delaware Corp · Topping, VAN9895FRetro Modern Aviation LLC · Manitou Springs, CON9895GKellerman Roger B · Rockford, ILN9895QCk Leasing Services LLC · Wilmington, DEN9895VTogo Aviation Services LLC · Palmer, AKN98960Buiqui Aerospace Corp · Kissimmee, FLN98961Knox Norman B · Billings, MTN98962Woodward Lowell L · Alpine, TXN98965Cook Steven A · Vineland, NJN9896PLees Aerial Spraying Inc · Aberdeen, IDN9896UAmaya Ricardo · Shelby, NCN9896WKnapp Joseph E Jr · Clermont, FLN9896YFrisby James A · Palmer, AKN98971Whitaker Eric Lee · Detroit, TXN98978Harmon Jon E · Turner, MTN98979Mc Bride Robert W Jr · Cedar Park, TXN9897DRobinson Scot K · Powderville, MTN9897PMississippi State University Soaring Club Inc · Mississippi State, MSN9897QAbove All Aviation Inc · Santa Barbara, CAN9897YCline Braxton L · Wasilla, AKN98981Airplane And Drone Flight Instruction LLC · Orlando, FLN98985Sanker Frank Trustee · Keller, TXN9898DBailey Ronald C · Anchorage, AKN9898QSecond Wind Aviation Corp · Friday Harbor, WAN9898UOlenick Christopher M · New Richmond, OHN98992Mike Pikovsky Aviation LLC · Plymouth, MNN98994Lindeen Michael L · Anchorage, AKN98999Rodenhouse Robert H · Port Orange, FLN9899GWings Over Texas LLC · Denton, TXN9899QBrown Richard K · East Falmouth, MAN9899UStott Rick T · Bynum, MTN989AMcghan Corey A · Big Lake, AKN989CDDoyle Charles P · Webster, MN
Back to AD 81-18-04 R2