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.
N5515QLassiter Bobby L · Newport, ARN5515SGotay Ricardo M · Watertown, CTN5515ZLandrum Kelly T · Halifax, VAN55160Davis Joseph S · Andalusia, ALN55163Jackson Donald W · Carthage, MSN55166Volando LLC · Columbia, MON55167Flyboys Nevada LLC · Henderson, NVN55169Jin Jin Aviation LLC · Anchorage, AKN5516FMoore Marcus · Auburn, ALN5516LBarnes Richard A · Federal Way, WAN5516SAtc Trucking Inc · Miami, FLN5516UHicks David A · Beaver Dam, WIN55173Dareing Chon · San Antonio, TXN55176Hall Davis · Mobile, ALN55177Saunders Ivan J · Margate, FLN55179Rick Aviation Inc · Newport News, VAN5517FMccarthy Mark C · Russellville, ARN5517KCarter Brantley F · Timmonsville, SCN5517MBas Part Sales LLC · Greeley, CON5517PVoorhees Kenneth J · Aiea, HIN5517QTrayhan Edward J · Schertz, TXN5517VWest Bryan M · Heath, TXN5518Campbell Larry L · Fort Mill, SCN55181Bluewater Airmotive Corp · Wilmington, DEN55182Sofla Sky Solutions LLC · Deerfield Beach, FLN55185Bailey Richard W · Auburn, ALN55187Aerospace Trust Management LLC Trustee · Wilmington, DEN5518KDiaz James F · Campbell, CAN5518UC1 Aviation LLC · New Orleans, LAN55197Bartlett Aviation LLC · Louisville, KYN5519CKukeeza LLC · Williston, NDN5519HOstendorff Eric C · Torrance, CAFirst renewal noticeN5519JGoodwyn Thomas M · Las Vegas, NVN551APCappe Investment Group LLC · Homestead, FLN551BWarbirds Of The World Air Museum · Los Lunas, NMN551BBMeridian Aircraft LLC · Wilmington, DEN551CCYale Companies LLC DBA · Indianapolis, INN551CMKeller Charles L · Henderson, NVN551EZAsis Robert O · Huntington Beach, CAN551JHN551jh Sky Holdings LLC · Grand Ledge, MIN551MDVero Technical Support Inc · Pensacola, FLN551MPKlesel Cameron S · Schulenburg, TXN551PASkowbo Rock G · Jacksonville, FLN551PGChavi LLC · Fredericksburg, TXN551PUSkyborne Airline Academy Inc · Vero Beach, FLN551TXCarrozza Louis R · Haymarket, VAN55200Skyhawk Flyer LLC · Monticello, IAN55203Mil2atp Inc · Pikeville, NCN55206Shipman Mark J · Nellysford, VAN5520DSwaeringen Eric · Snohomish, WA
Back to AD 90-04-06 R1