AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N41331Heath Andrew · Lafayette, INN4133EHouse Larry A · Anchorage, AKN4133PCoulson Michael D · Zanesville, OHN4133XAnfuso Keith · La Habra Heights, CAN41342Papoutsis Thomas J · Chambersburg, PAN41343Lkr Aviation LLC · Buckeystown, MDN41348Low George D · Newport, MIN41349Minot Aero Center · Minot, NDN4134JPriebe Aviation LLC · Waseca, MNN4134TDavis Stephen · Madera, CAN4134ZHuseby Terry L · Hulett, WYN41357Air Trek North LLC · South Saint Paul, MNN41359Ayubi-Moak Jason S · Chandler, AZN4135DChristiansen Aviation LLC · Wilmington, DEN4135HSommer John J · Seattle, WAN4135MHardy Val D · Lewistown, MTN4135WTexins Flying Club · Mckinney, TXN4135YMoore Steven J · West Ossipee, NHN4136Johnston Joel D · Mead, WAN41360Cross Thomas Ad · Yacolt, WAN41361Excell Air Filters LLC · Ashland, OHN41369Ascent Aviation Inc · Van Nuys, CAN4136ENelson Gregory A · Anchorage, AKFirst renewal noticeN4136HMetzler Kevin W · Rosamond, CAN4136MArmstrong Charles · Shelbyville, MIN4136PN4136p LLC · Titusville, FLN41372Gorham Raymond A · Lock Haven, PAN41376Berkshire Aviation Enterprises LLC · Great Barrington, MAN41379Dzedzy Theodore Andrew Jr · Schwenksville, PAN4137LLuv 2 Fly Ada LLC · Ada, OKN4137ZAtg Enterprises Inc · Aztec, NMN41380Aristizabal Leonardo · Woodland Hills, CAN41383Lamontagne Bradley Theodore Jr · Pleasant View, TNN41387Horizon Aviation LLC · Brooks, GAN41389Johnson David C · Chisago City, MNN4138HMiller John A · Ballston Lake, NYN4138JRegistration Pending · Orlando, FLRegistration pendingN4138PFreyburger Gregory P · Strykersville, NYN4138XBroadwell Eric B · Woodstock, GAN4138ZZweifel Douglas L · Anchorage, AKN41391Aurora Aviation Lc · Pierce City, MON41399Beck Paul R · Knoxville, IAN4139JWolles Joseph · Dell Rapids, SDN4139MWhiteley Jeffrey L · Jefferson, ORN4139YPremier Management Co Inc · Mobridge, SDN4139ZL Sheffels And Son Inc · Wilbur, WAN413AAAmerican Aviation Inc · Brooksville, FLN413ABBaxter Thomas L · Stockbridge, GAN413BBRegistration Pending · Iron Station, NCRegistration pendingN413BXAlbrecht Devin C · Shavertown, PA
Back to AD 90-04-06 R1