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.
N8594CNagia Omar Mohamed · Richmond, CAN8594EMehlbauer Robert B · Owensboro, KYN8594FPiper Aircraft Inc · Vero Beach, FLN8594NKosciusko Skipper N · West Cornwall, CTN8594VCosta James J · Tulare, CAN8595DPiper Aircraft Inc · Vero Beach, FLN8595MMohle Darren · Carlsbad, CAN8595VAnacortes Associates LLC · Anacortes, WAN8595YKor Reese W · Piedmont, SDN8596NLsg Flying Services LLC · Sarasota, FLN8596YLeap Aviation Inc · Wilmington, DEN8597DRwr Air Inc · Tol, AKN8597VSitta Donald C · Farmington, NMN8597YTaylor Douglas S · Fairfield, CAN8598CFrenzel Robert P · Midlothian, TXN8598DBurkhart Verlus L · Fairmont, MNN8598YGulf Coast Aviation LLC · New Orleans, LAN8599NScott Lauren M · Lighthouse Point, FLN8599VObx Airplanes LLC · Manteo, NCN859CPN859cp LLC · Boynton Beach, FLN859DCIsr Aviation LLC · Wilmington, DEN859JLZabransky Gregory J · Mineola, TXN859MHHarrington Mark · West Milford, NJN859RAThree Green Inc · Wilmington, DEN859RKRisk Indemnification Professionals LLC · Anchorage, AKN859SCFf22 LLC · Scottsdale, AZN859SPJet Air Inc · Iowa City, IAN859TRaven Aviation LLC · Lexington, KYN85ALLee Donald Robert · Talkeetna, AKN85BKBkv Aero Squadron LLC · New Port Richey, FLN85BMMc Crorie Robert A · Sequim, WAN85BRPalmer Travis S · Maupin, ORN85BWSayler Nathan T · Valley City, NDN85CSeay Edward A · Signal Mountain, TNN85DCCaesar David R · Justin, TXN85DGGarrison Stephen L · Johnson City, TNN85EZLarock Ronald R · Fairhaven, MAN85FASilver Express Co DBA · Miami, FLN85FTSpain Ryan D · Shelbyville, ILN85FZZeller Francis J · Rosamond, CAN85GPRay Hardee · Dupont, WAN85HMArmey Andrew D · Fresno, CAN85HQThielbar Bruce A · Lake Arrowhead, CAN85HYGades Allen L Trustee · Montevideo, MNN85JBBurke Jonathan · Berkeley, CAN85JCRichey Michael A · Fort Laramie, WYN85JFFleeman Joseph R · Lawrenceburg, TNN85JWWhittington Robert W · Blackwell, OKN85KWN85kw LLC · Avon, INN85LSScholten Calvin B · Lakeland, TNFirst renewal notice
Back to AD 90-04-06 R1