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.
N75153Island Aviation Management LLC · Daytona Beach, FLN75158Bowman Aviation LLC · Sebewaing, MIN7515HWrabetz Michael J · Anchorage, AKN7515JCrock Brent S · Enterprise, ALN7515KHartman John E · Rangely, CON7515RRoquet Steven L · Fremont, IAN7515VRxair 2 Inc · Bella Vista, ARN7515WAir Services Inc · Roca, NEN7515YJohnson Max L Jr · Greenville, SCN75162Mccann Michael H · Santa Ynez, CAN75163Bryant Donald Kelly · Sullivan, MON75164Sinkovich Pete · Phoenix, AZN75165Maple Shores LLC · Helena, MTN75169Flight School Inc · Spring, TXN7516DRoot Eric J · Lakewood, CON7516FMahan Phillip A · Juneau, AKN7516JBeard Don Ricarde · Rockledge, FLN7516KMattie Joseph G · Ester, AKN7516VOgletree Ben R Jr · Livingston, TXN7516WGreen Andrew · Hillsboro, TXN7517410 Skies LLC · Rockport, TXN75177Labrash Barbara J · Eastsound, WAN75179K4-S Flight Training LLC · Santa Rosa, CAN7517DSoltura Ariel · Chappell Hill, TXN7517HBass Douglas A · Sterling, AKN7517JWright Aviation LLC · San Francisco, CAN7517KEckels Daniel R · Centerburg, OHN7517RGarringer William E · Pryor, OKN7517UNg&C Trucking LLC · Carrollton, GAN7517VSims Albert Paul · Auburndale, FLN7517WVaquillas Trading Co Ltd · Aguilares, TXN75182Donkel Douglas L · Hillsboro, ORN75186Lessenberry James F · Leonard, MIN75187N75187 LLC · Fulton, MON7518FKlassen Orvil H · Mountain Lake, MNN7518JEsposito Michael I · Raleigh, NCN7518KHarris Hill Soaring Corp · Horseheads, NYN7518PLasswell Joel E · Arcola, ILN7518WNywhb Properties · Westhampton Beach, NYN7518YAlba Aviation Services Inc · Scottsdale, AZN75190FAA Flying Club Inc · Atlantic City, NJN75193Groton Flyers LLC · Bozrah, CTN75198Flightline LLC · Kaysville, UTN7519FBohlman Todd L · Lemon Grove, CAN7519KErickson Roger · Hamill, SDFirst renewal noticeN7519YDunshee Kevin G · La Luz, NMN751BKGeneral Aviation LLC · Henderson, NVN751BSVenture North Aviation LLC · Cloquet, MNN751HKBolin Steven D · Midland, TXN751KSWarstler Michael · Dayton, OH
Back to AD 90-04-06 R1