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.
N7942BPuckett Jeffrey F · Rector, ARN7942TLinebaugh Ricky L · Dover, PAN7942ZBrown David L · Hughesville, MON7943BMoul Dale E · Boise, IDN7943EQuisenberry Richard S · Marietta, OKN7943FRegistered aircraftN7943ZAlrubaiie Ihssan Robert · Fort Worth, TXN7944BHarms Steven Lee · Cedar Rapids, IAN7944FBrown R Ed · Vandalia, ILN7944ZFreeman J · Memphis, TNN7946BBrock Raymond Richard · Crescent, IAN7946FPaul Paulson A · Kipnuk, AKN7946TWright Anthony · Tallahassee, FLN7946UUpper Aircraft International LLC · Titusville, FLN7947BJames Bobby F · Bloomfield, INN7947THarris Billy M · Waco, TXN7947ZBouchard Jamie Claude · Berwick, MEN7948BGruber Barbara L · Centreville, VAN7948TJolley Jonas D · Woodstock, GAN7948ZRlh Montana LLC · Helena, MTN7949BHeffron Jacob L · Little Falls, MNN7949EPurstell Kevin · Burnt Hills, NYN7949FMaciol Michael W M D · Pelham, NYN7949ZFlores Carah L · Perris, CAN794CTCarolina Custom Farm Equipment LLC · Wilson, NCN7950BBobka Christian · Apple Valley, MNN7950EGanskop Brandy D · Flaxton, NDN7950TSchroeder Henry G · Lacombe, LAN7950UBowden James E Jr · Eufaula, ALN7951BRocky Creek Jbd Inc · Boca Grande, FLN7951TClair Brent A · Loraine, ILN7951URegistration Pending · New Smyrna Beach, FLRegistration pendingN7952BEmaw Properties LLC · Ketchum, OKN7952FKagey Ryan D · Seabrook, TXN7952GPlunkett Charles K E · Eagle Point, ORN7952TGregg John I Jr · Glendale, AZN7952UTigger II Airways LLC · Towson, MDN7953BSavener Eric D · Kingsland, TXN7953GSnyder Kenneth C · Lonsdale, MNN7953ZMartin Aviation LLC · Bargersville, INN7954FVikingland Flying Club · Alexandria, MNN7955BCochrane Geoffrey G · Seville, OHN7955FN7955f LLC · Titusville, FLN7956FFios Flightline LLC · Tucson, AZN7956USweeney Daniel N · Radcliff, KYN7956XNesbit Stephen M · Chino Hills, CAN7957ELynn Kerry E · Stow, MAN7957XRoderick Ashley T Jr · Hixton, WIN7958BThrustline Aviation LLC · Happy Valley, ORN7959BLaminack Dale Wayne · Ralls, TX
Back to AD 94-05-05 R1