AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1')
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:94-05-05-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:94-05-05-R1') 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.
N70539Huntington Thomas R Jr · Ormond Beach, FLN7053APearsall Timothy R · Rexford, NYN7053UWaterman James T · San Antonio, TXN70548Klingebiel Sean R · Schuylerville, NYN7054AOtt Rex A · Burlington, IAN7055EKleinschmidt Eric W · Livermore, CAN70561Maples Charles S · Fairfax, VAN7056THeinke John R · Paradise, CAN7057EKoser Michael D · Asheboro, NCN7058FTechnical Education Services Inc · Virginia Beach, VAN7059AWebster Mark Lawrence · Frankston, TXN7059EPennell Zackaria S · Canyon Lake, TXN7059TBrommer Roger A · Lino Lakes, MNN705TDFlight Gear Aviation LLC · Pickerington, OHN70604Cole Audrey L · Anchorage, AKN70605Zabinski Ted W · Voorheesville, NYN7060AWalker Jonathan S · Council Bluffs, IAN7060EBrenner Valerian · Port Saint Lucie, FLN7060SDygas Pauel · Pomerene, AZN70614Flaspoehler Benjamin P · Greenville, SCN70615Malinchak Joseph G · Greenfild Twp, PAN7061SDirar Farras S E · Sackets Harbor, NYN7062SPrecision Aerospace Corp · Sarasota, FLN7062TJardd Inc · Lorain, OHN7063ASexton Forest · Eagle Point, ORN7063HN7063h Inc · Miami, FLN7063TMorris Coady C · Russell, KSN7064ASelby Joshua F · Condon, ORN7064EBolognese Joseph · Las Vegas, NVN7064SCuddington Mark E · Puyallup, WAN70656Rawliuk Robert A · Tok, AKN7065AJahnke Michael D · Wichita, KSN7065MPamair Inc · Wilmington, DEN7065TRegistered aircraftN7066ANewton Consulting & Engineering Inc · Tucson, AZN7066EBarnes Stephen W · Mustang, OKN7066FLamb Barry J · Moran, KSN70675Lavigne Richard P · Ranier, MNN7067AWhitemire Jospeh A · Soddy Daisy, TNN7067E5 Am Equipment LLC · Casper, WYN7067TSmith Roy Harold · Whiteville, NCN7067XAlpha Golf LLC · Glenpool, OKN7068AMcdonald Ronald B · Arcadia, FLN7068EMarino Farms LLC · Macon, MON7068FAndrew David N · Manhattan, ILN7068MStaples Norman J · Sussex, WIN7069EPinnell John T · Bakersfield, CAN7069MJohnson Roger N · Winnemucca, NVN7069THovey Terry W · Rogue River, ORN706JDBartels Gary A · Daykin, NE
Back to AD 94-05-05 R1