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.
N63ABAircraft Leasing & Management LLC · Lewes, DEN63AKWinchell Lawrence R III · Salem, NJN63AMSierra Yankee Victor LLC · Austin, TXN63ANNugent Alasdair · Mount Ephraim, NJN63BASullivan Richard P · Star, IDN63BCValleortiz Hector J · Laurel Hill, NCN63BESutton John S · Pelham, ALN63BGDenali Asset Management LLC · Incline Village, NVN63BSPfinx LLC · Chapel Hill, NCN63CLThomas Matthew L · Lakeland, FLN63CTSmith Glenn C · University Place, WAN63CVClark Terry L · Bartlesville, OKN63DABass Lake Aviation LLC · Webster, WIN63DGMiller Colette L · Sequim, WAN63DMDurbin Hal E · Findlay, OHN63DTTanona Duane T · Enumclaw, WAN63EZWorley Dan L · Heber Springs, ARN63FEFour Macs Logistics LLC · Houlka, MSN63FHRegistered aircraftN63FKHawley Robert W · Fort Worth, TXN63GOneil Liam Trustee · Vashon, WAN63GKRawareo LLC · Warsaw, MON63GMBmi Aviation LLC · Hallandale Beach, FLN63GSAerial Surveys Inc · Dover, DEN63HESkoog Rodney D · White Bear Lake, MNN63HYTailwheel Pilots LLC · Lacon, ILN63JDD'Angelo Joseph P · Callicoon Center, NYN63JWRegistered aircraftN63KBBeene Kenneth E · Waco, TXN63LDKnudsen Allan L · Council Bluffs, IAN63LUChristiansen Aviation LLC · Wilmington, DEN63MKPeterson Grant · Mclean, VAN63MMNzere Michael · Crowley, TXN63MSSire Daniel T · Wausau, WIN63MTGriffith Gary L · Palestine, TXN63PEGoodinson Marc D · Hamburg, NJN63PKRegistered aircraftN63PLBoeing Employees Flying Club St Louis Inc · Saint Louis, MON63PNDga Aviation LLC · Sacramento, CAN63RMclenaghan Alvin N · Phoenix, AZN63RH4-D Aviation Consulting LLC · Wilmington, DEN63RLVolland Aimee C · Tavernier, FLN63RWSmith Jacques F · Anchorage, AKN63SASky View Aviation LLC · Lenoir, NCN63SMMoore George L · Spring Hill, KSN63TXKilly James · Littleton, CON63VLPulsar Investments Inc · Scottsdale, AZN63WALariscey Adam · Lyons, GAN63WFThompson Kevin J · Three Rivers, CAN63WMSmith Russell M · Bokeelia, FL
Back to AD 90-04-06 R1