AD 91-21-01 R1
Registered aircraft · 5,086
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:91-21-01-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:91-21-01-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:91-21-01-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:91-21-01-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.
N7392VBrown Mill Ranch LLC · Lamar, CON73CZBm Air LLC · Anaconda, MTN73DNMurdoc Aviation LLC · Destin, FLN73LKMoore David E · Stuart, FLN73RTRegent Trust Corp Trustee · Wichita, KSN73RWSeppala Joel H · Taylors, SCN73WHBumble Bee Aviation LLC · Brookfield, WIN740HCVuksanovic David A · Fountain Hills, AZN7411SNaik Narayan · Claremore, OKN74199Aldrich Curtiss R · Aguila, AZN7419SKcantarano LLC · Mukilteo, WAN7425SSweeney Sean M · Reunion, FLN7426LWright Air Service Inc · Fairbanks, AKN742HMBennett Aviation LLC · New York, NYN7432LStandard Air LLC · West Linn, ORN7434LIsland Wings Inc · Fort Lauderdale, FLN7438SFrana Joel A · Fort Myers, FLN7441SKp Stunt Productions Inc · Burlington, NDN744JCAck-Pg-LLC · Charlestown, MAN744RVAustin Aviation LLC · Maumelle, ARN745AALarson Stephen Blair · Raleigh, NCN746AJNesta Joseph A · Kelleys Island, OHN746RRSolis Inc LLC · Alton, NHN747ATHaueisen Jessica · Franklin, GAN747CGAir Americus LLC · Johns Creek, GAN747HSale Reported · Santa Rosa, CASale reportedN747MEEvans Mark W · Camillus, NYN7482WSkys Edge Aviation LLC · Midland, TXN748NPBelle Island Management LLC · Fort Lauderdale, FLN74932Ruocco 220 LLC · Escondido, CAN7496SSmith Linda L · Port Charlotte, FLN74972H&H Aircraft LLC · Grey Eagle, MNN74BBHy Aviation LLC · San Juan, PRN74DDN74dd Inc · Apalachicola, FLN74LRRemy Lange · East Greenville, PAN74MJFord Richard M · Cartersville, GAN74PLAncient Pelican Aviation LLC · Vero Beach, FLN74WDNevada Viking Partners LLC · Stateline, NVN75014Hammonds Hangars Inc · Wilmington, DEN75034Rpm Aviation LLC · Hillsborough, NCN7503SStout Joel D DBA · New Cumberland, PAN7507SBlue Sky Aviation Inc · Texico, NMN7509SBlueskys Inc · Wilmington, DEN750AWMagumbo Aviation LLC · Macomb, MIN750GVTrak Inc · Gainesville, GAN75143Raisch Horst F · Aptos, CAN75195Swaz Aviation LLC · Mesa, AZN75196Woodberry Robert A · Mineral, VAN75247G W R LLC · Wilmington, DEN75267Avian Aerospace LLC · Mansfield, OH
Back to AD 91-21-01 R1