AD 53-08-01
Registered aircraft · 747
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:53-08-01')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:53-08-01')
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:53-08-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:53-08-01') 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.
N4180KCooper Melvin R Jr · Prineville, ORN4183KGroth Matthew C · Arlington, WAN4185KKennedy John E · Martinsville, INN4188KMartino Victor H · Port Wentworth, GAN4190KPflaum Dudley T Trustee · Henderson, NVN4191KWells David M · Ada, MIN4193KPrice Steven C · Midland, TXN4197KRichardson Walter J Jr · Aliceville, ALN4201KSuttles B Hugh · Walhalla, SCN4202KNavion Aviators LLC · Greenwood, MSN4210KBosch Kent D · Montevideo, MNN4213KPontiff Elizabeth D · Sterling, VAN4214KChristopher Michael L · Gerlach, NVN4224KDickson Robert T · Charlotte, NCN4226KTroeleman Adrian John · Naples, FLN4229KLead And Brass Racing LLC · Helena, MTN422HJTomlinson Paula L · Redmond, WAN4230KHarper Paul V · Minerva, OHN4238AHigh Noon Aviation LLC · Loveland, CON4241KSmith Glen R · Tracy, MNN4242KNaviation LLC · Kalispell, MTN4244KKlungle William C · Grand Haven, MIN4251KVlahakis Gregory G · San Jose, CAN4254KRankin Gary L · Meade, KSN4255KWheeler Douglas A · Mount Vernon, OHN4262KBeaver Richard G · Spring, TXN4264AReed William B · Cortlandt Manor, NYN4264KBejvan David E · Milwaukee, WIN4267KStrength Vernon E · Eureka, CAN4271KMoeding Michael M · Emporia, KSN4276KDunn Emet C III · Coolidge, AZN4278KUrubek Raymond L · Refugio, TXN4281KSperl Robert D · Keymar, MDN4284KHornblower Paul S · Chilmark, MAN4286KDeemer Jerry C · Granbury, TXN4287KGarre William C · Flint, TXN4288KKrug III George R · Keller, TXN4289KForsberg Edwin E · Elk Grove, CAN4294CBaldwin Stephen A · Olalla, WAN4305KSeferian Matthew C · Omaha, NEN4309KRezich James N · Winnebago, ILN4312KJorsey Allen Jr · Reidsville, NCN4315KFridley John K · Palatka, FLN4317KEdwards Freeman Allen · Lake Butler, FLN4319KWings Den LLC · Wilmington, DEN4321KAmerican Airpower Heritage Flying Museum · Dallas, TXN4323KRothfleisch Joseph Ryan · Brawley, CAN4328KSpringer Kelly · Edmonds, WAN4331KAviation Systems Engineering Company Inc · Lexington Park, MDN4332KAmerican Airpower Heritage Flying Museum · Dallas, TX
Back to AD 53-08-01