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.
N465CTMatter Terrence K · Reno, NVN465CWSkyking LLC · Lake Stevens, WAN465DLKeystone Aerial Surveys Inc · Philadelphia, PAN465EPRainier Flight Service LLC · Renton, WAN465FARondeau Inc · East Norriton, PAN465HMMorse Don W DBA · Priest Lake, IDN465KBBelue Kevin D · Madison, ALN465PEHoyle Jason R · Grove, OKN465SAGilmore Air LLC · Boca Raton, FLN465TByrds Wholesale Inc · Clayton, NCN46601Skywarrior Flight Training Inc · Pensacola, FLFirst renewal noticeN4660AConnealy Air LLC · Whitman, NEN4660BEllison Orlo T · Broomfield, CON4660DSale Reported · Milwaukee, WISale reportedN4660GAdvantage Aviation Inc · Palo Alto, CAN4660JStuder Al C · Shelby, MIN4660KFoster Gary Paul · Willow, AKN4660NCasey Kellie M DBA · Fort Worth, TXN4660ROgren William E · Red Wing, MNN4660YManess Gary D · Eagle River, AKN46612Dugger Joey D · Nine Mile Falls, WAN46613Mad Cap Inc · Smithfield, RIN46615Lindsay William G · Santa Paula, CAFirst renewal noticeN46616Koubsky Richard L · Hollywood, SCN4661AOlson Eric T · Hudson, WIN4661CZiesmer Richard A · University Place, WAN4661MF & W Aviation Co LLC · Wilmington, DEN4661RSternberg Alexander J · Key Largo, FLN4661TPowell Christopher T · Moosic, PAN4661ZRustair Inc · Anchorage, AKN46620Cantrell Jason L · Aberdeen, MSN46621Lake Clark Holdings LLC · Port Alsworth, AKN46622Wings Over Texas Holdings LLC · Denton, TXN46624Kda Aviation LLC · East Granby, CTFirst renewal noticeN46629Brock Robert L · Tonganoxie, KSN4662EJgm Aviation LLC · Marion, MTFirst renewal noticeN4662JBigby Calvin J · Savannah, GAN4662PCorn Michael L · Wilmington, NCN4662UMeadow Lakes Aviation · Wasilla, AKN46631Keenan Joseph P · Fort Lauderdale, FLN46632Dehn Charlene M · Victor, NYN46636King James E · Port Angeles, WAN46638Pro Aviation LLC · Sanger, TXN4663CKnox William D · Denver, CON4663JMetro Flying Club · Gilbert, SCN4663RLockwood Michael C · Edmond, OKN4663WMoeller Thomas R · Evergreen, CON46640Bryant William S · Kilmarnock, VAN466421028 Flying Club LLC · Statesville, NCN46643Volunteer State Aviation LLC · College Grove, TN
Back to AD 2007-04-19 R1