AD 2007-04-19 R1
Registered aircraft · 108,434
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:2007-04-19-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:2007-04-19-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:2007-04-19-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:2007-04-19-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.
N551BWarbirds Of The World Air Museum · Los Lunas, NMN551BBMeridian Aircraft LLC · Wilmington, DEN551BGOne Bravo Gulf LLC · Lutz, FLN551BKCedar Ridge Aviation LLC · Knox City, TXN551BW602 Xx LLC · Springdale, ARN551CCYale Companies LLC DBA · Indianapolis, INN551CDBwr Group LLC · Hobbs, NMN551CMKeller Charles L · Henderson, NVN551DBKirby Ramsey Aviation Group LLC · Almont, CON551DSFreeburg Farms Inc · Worley, IDN551ERSunrise Aviation Inc · Ormond Beach, FLN551ESNimno 551es LLC · Pompano Beach, FLN551GJanes Christopher D · Columbia, KYN551JACalderon Gustave P · Carlsbad, CAN551JBValiair Lc Trustee · Casper, WYN551JHN551jh Sky Holdings LLC · Grand Ledge, MIN551JSEm Concepts LLC · Cape Coral, FLN551LAHamlin 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, FLN551SFFilmlites Montana LLC · Bozeman, MTN551TN551t LLC · Hesston, KSN551TSAbc Air Inc · Eveleth, MNN551TXCarrozza Louis R · Haymarket, VAN551USFar Side Aero LLC · Santa Maria, CAN551ZLGlascock 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, WAN5520NChristiansen 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, VAN5521BHunt Nicholas R · Bozeman, MTN5521FMarc Inc · Brandon, MSFirst renewal noticeN5521JVanrider Jeffrey F · Wildwood, FL
Back to AD 2007-04-19 R1