AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N5518TBlue Sky Group Inc · Wilmington, DEN5518UC1 Aviation LLC · New Orleans, LAN5518WChristiansen Aviation LLC · Wilmington, DEN55197Bartlett Aviation LLC · Louisville, KYN5519CKukeeza LLC · Williston, NDN5519GBalkema Jeff · Scotts, MIN5519HOstendorff Eric C · Torrance, CAFirst renewal noticeN5519JGoodwyn Thomas M · Las Vegas, NVN5519VMercer Asa · Manderson, WYN551AJSo Fine Air LLC · Palm Beach Gardens, FLN551APCappe 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, NVN551ERSunrise Aviation Inc · Ormond Beach, FLN551ESNimno 551es LLC · Pompano Beach, FLN551EZAsis Robert O · Huntington Beach, CAN551JHN551jh Sky Holdings LLC · Grand Ledge, MIN551LAHamlin Co · Long Beach, CAN551MPKlesel Cameron S · Schulenburg, TXN551NDCoast Flight Training And Management Inc · San Diego, CAFirst renewal noticeN551PASkowbo Rock G · Jacksonville, FLN551PGChavi LLC · Fredericksburg, TXN551PUSkyborne Airline Academy Inc · Vero Beach, FLN551TXCarrozza Louis R · Haymarket, VAN551ZLGlascock Devin Duwaine · Clovis, NMN55200Skyhawk Flyer LLC · Monticello, IAN55203Mil2atp Inc · Pikeville, NCN55206Shipman Mark J · Nellysford, VAN5520DSwaeringen Eric · Snohomish, WAN5520FChicago Air LLC · Chicago, ILN5520KHillstrom Rudolph A · Oakville, WAN5520LBlue Feathers Corp · Newark, DEN5520NChristiansen Aviation LLC · Wilmington, DEN5520POdonnell Nathan Ray · Enterprise, ALN5520QStefanov Mark C · Georgetown, TXN5520SChristiansen Aviation LLC · Wilmington, DEN5520UChristiansen Aviation LLC · Wilmington, DEN5520XUS Aviation Training Solutions Inc · Titusville, FLN55211Skylens LLC · Hammond, LAN55214N55214 LLC · Celina, TXN55215Zarama Jose · Easley, SCN55216Huizar Victor · Albuquerque, NMN55218Christiansen Aviation LLC · Wilmington, DEN55219Wilkinson Thomas W · Weyers Cave, VAN5521FMarc Inc · Brandon, MSFirst renewal noticeN5521JVanrider Jeffrey F · Wildwood, FLN5521KBrowning Ricou R Jr · Melbourne, FLN5521PSkyview Aviation Services Inc · Lakeland, FL
Back to AD 81-18-04 R2