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.
N7233JPinnick Andrew · Beckley, WVN7233KWalsh Steve · Anchorage, AKN7233YPacific North Air LLC · Portland, ORN7234FBrinker Joe E · Little Hocking, OHN7234GBittenbender Peter E · Grand Rapids, MNFirst renewal noticeN7234QLavinio Stephen E · Southampton, NYN7234WMoco Aviation LLC · Moultonborough, NHN7235GMcnair William H · Gold Beach, ORN7235WMorris George · Redlands, CAN7236DGo North Productions LLC · Glennallen, AKN7236FRegistered aircraftN7236JBackman Randy L · Bellingham, WAN7236KSchwend Brian · Forsyth, MTN7236MWright Steven William · Bend, ORFirst renewal noticeN7236PMark A Smith Aircraft Sales Inc · Homosassa, FLN7236QTeren Nelson F · Friday Harbor, WAN7237DBobinchak Richard G · Sheridan, WYN7237GIvoprop Corp · Long Beach, CAN7237QMartin Bach Aviation LLC · Cornelius, NCN7237WPetropulos James J · Juneau, AKN72383Niagarawings Aviation LLC · Niagara Falls, NYN7238FDoll William J · Carlisle, PAN7238KGarber Bruce E Trustee · Sheridan, WYN7238LHorizon Flight Center LLC · Chesapeake, VAN7238WRupert Shon D · Greenwood, ARN7239DHaning Thomas B · Vian, OKN7239KHodgson Joel R · Palmer, AKN7239PMccabe Gregory · Melbourne Beach, FLN7239WWiza Jason · Custer, WIN723AGShortt Aircraft Leasing LLC · Wilmington, DEN723AJCavorite Aviation LLC · West Jordan, UTN723AKFrohnapfel Mark T · Cordova, AKN723CCavner Hudson A · Port Alsworth, AKN723CJNicholson Scott V · Kalamazoo, MIN723CLVan Why Johnathan Ryan · Corvallis, ORN723CMOmbra Aria LLC · Dover, DEN723CTN723ct LLC · Bend, ORN723ENichols Charles F Trustee · Baldwin Park, CAN723GPuerta Jose Fernando Del Valle · Miami, FLN723GALong Island Aviators LLC · Seaford, NYN723JSAlbertson James M · Westville, FLN723KCCornelius Robert · Vinemont, ALN723LHParker Robert · Oklahoma City, OKN723MLVertical Corp · Kalispell, MTN723PC43rd Aviation Flying Club Inc · Norfolk, CTFirst renewal noticeN723PGPoplar Grove Airmotive Inc · Poplar Grove, ILN723PMCeu LLC · Greer, SCN723RVSmith Stuart T · Murrieta, CAN723SSmaltz David I · Newmanstown, PAN723THSouthern Aircraft Consultancy Inc Trustee · Casper, WY
Back to AD 90-04-06 R1