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.
N738UWAircraft Management Services Inc · Milton, FLN738UYOptima Aviation LLC DBA · Lewisville, TXN738VAFive Rivers Flight Training LLC · Livermore, CAN738VBBrafa Frank T · Leesville, LAN738VCMarlin Walter E II · Locust Grove, GAN738VJCommand-Aire LLC · Seattle, WAN738VLBasler Leon E · Sainte Genevieve, MON738VRWoodward Tyler James · Norman, OKN738VUFive Rivers Flight Training LLC · Livermore, CAN738VVPureflight Aviation Training LLC · Newberg, ORN738VYRpm Aero LLC · Lincolnwood, ILN738WBNord Aviation Inc · Pembina, NDN738WCBrb Grand-Air LLC · Indiantown, FLN738WEBray Aviation LLC · Calera, OKN738WGZlock David · Lakeville, MNN738WHPiraino Philip A · Middletown, DEN738WJSpann Leonard D · Little Rock, ARN738WLBrenair Inc · Mcalester, OKN738WMMayers Trevor D · Miami, FLN738WNSkywarrior Flight Training LLC · Pensacola, FLN738WRRoberts Dwight C · Seminole, OKN738WYIsland Aircraft LLC · Anchorage, AKFirst renewal noticeN738WZPitman Steven M · Lyman, SCN738XAHyldburg Aviation · Plymouth, MAN738XDMls Aviation LLC · Yorba Linda, CAN738XFTynan Flyers LLC · Tynan, TXN738XGWest Central Georgia Flying Club · Thomaston, GAN738XKBailey James D Trustee · Marana, AZN738XLM&A Aviation LLC · Vine Grove, KYN738YBMark Stoughton · Salley, SCN738YCN738yc LLC · Fresno, CAN738YHWebster Deryl Thomas · Angola, INN738YJOzarka College · Melbourne, ARN738YLCarter Flygare Inc · Sacramento, CAN738YPFuselier Byron · Rayne, LAN738YRYankee Romeo LLC · Wilmington, DEN738YSHood Jerry R · Double Springs, ALN738YTB2fh Ltd · Allentown, NJN738YWLeemon Kenneth V · Scottsdale, AZN738YXHogan Patrick B · Simpsonville, SCN738YZHotton Ralph A · Canton, MIN738ZASale Reported · Ogden, UTSale reportedN738ZCN738zc LLC · Tallahassee, FLN738ZDChristiansen Aviation LLC · Wilmington, DEN738ZELagow Virgil M Ll · Muskogee, OKN738ZFMann Don R · Mount Vernon, OHN738ZGPopescu Daniel · Nokesville, VAN738ZHRegistration Pending · La Porte, TXRegistration pendingN738ZLGoyal Vishal · Walnut Creek, CAN738ZMAero Lease And Trading LLC · Miami, FL
Back to AD 90-04-06 R1