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.
N6888HN6888h LLC · Wayne, NJN6888NGrass James Conrad · Phoenix, AZN6888WAnderson Ty M · Grenada, MSN68890Capital Air Services LLC · Ridgeland, MSN688AMFox Three Holdings LLC · Waukee, IAN688BGJones William E · Birmingham, ALN688CABetter Southlake Properties LLC · Pagosa Springs, CON688CMIcan Solutions LLC · Fargo, NDN688HZumbrun Dennis L · Montz, LAN688LHChristiansen Aviation LLC · Wilmington, DEN688NDUnd Aerospace Foundation · Grand Forks, NDN688PAJoe P Fassio · Union, WAN688RMBurton Jason S · Howell, MIN688TAircapital Nevada Inc · Carson City, NVN6890RBudgeon Mark K · Mandeville, LAN6890WRegistered aircraftN6891BSchachle Theodore A · Willow, AKN6891HRegistration Pending · Uvalde, TXRegistration pendingN68920Richmor Aviation Inc · Hudson, NYN68926Wings Over Texas Holdings LLC · Denton, TXN6892JHunter Trevor C · N Ogden, UTN6892NStratte Joseph J V · Yakima, WAN6892WRussell Steven D · Waxhaw, NCN68931Denman Diana L · Plain, WIN68934Bapes Debra L · Powell, OHN68938Wingspan 152 LLC · Valparaiso, INN6893EArmstrong Bruce · Port Orchard, WAN6893FAligence Air LLC · Spring Hill, FLN6893URk Management LLC · Garden City, KSN6894JPiontek Theodore J · Housatonic, MAN6894UShonrock Clinton O · Los Alamos, NMN6894WSummit Flight Academy LLC · Peculiar, MON68954Wings Over Texas Holdings LLC · Denton, TXN68956Spartan Education LLC · Tulsa, OKFirst renewal noticeN6895KRiemer Emil F · Brush Prairie, WAN6895NLadd Noel Joseph Espinosa · Edmond, OKN6895PDavis Jack J · Rifle, CON6895UWoodward Jeffery F · Viroqua, WIN6895WSale Reported · Brighton, COSale reportedN68961Shouling & Philip Enterprise · Lancaster, CAN68963University Of Michigan Flyers Inc · Ann Arbor, MIN6896HBuiqui Aerospace Corp · Kissimmee, FLN6896NHarding Ronald D · Spokane, WAN6897BCape May Aerial Advertising LLC · Cape May Ch, NJN6897CSchumann Donald A · Naperville, ILN6897UStyer David B · Pendleton, ORN6897WMcdowell Robert D · Snohomish, WAN68985Mcvicker Andrew B · Erwinna, PAN6898HS J Holding LLC · Wilmington, DEN6898NMcdonald John A · Dublin, OH
Back to AD 90-04-06 R1