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.
N5697ERedstone Arsenal Flying Activity · Redstone Arsenal, ALN5697JRidgway Rick J · Carlisle, INN5697KMerimont Aviation LLC · Dyersburg, TNN5697QReed Timothy W · Terrell, TXN56986Loya Armando · Whittier, CAN56987Ravotti Air LLC · Leechburg, PAN56988Hillerman Paul J · Vinita, OKN56989Kenny Zachary D · Herndon, VAN5698BTilley Melvin D · Sperry, OKN5698KSmith Ronald E · Jefferson, TXN5698QCaughell David S · Bartlesville, OKN5698SNewell Gary A · Colmar, PAN5698UNorby David S · Gooding, IDN5698WBurkett Aviation LLC · Hampstead, NCN56991Schneider Stephen C · Denton, TXN56992Attebery Larry J · Caldwell, IDN569932c Fun Aviation LLC · Dallas, TXN56996Zarn Douglas J · Amboy, MNN56997Bibb John G · Paragould, ARN56999Lofty Images LLC · Owosso, MIN5699DClear Lake Management Corp · Wilmington, DEN5699KMoore Joseph M · Santa Barbara, CAN5699NStyer David B · Pendleton, ORN5699PHahn Curtis D · St George, UTN5699ULrh Equipment LLC · Pendleton, ORN5699VMesmer Robert F · Grand Island, NYN569ARN717dz LLC · Lovell, WYN569BSZanetta Wayne T · Portland, ORN569CDUltimate Holdings LLC · La Grande, ORN569CPCivil Air Patrol · Maxwell Afb, ALN569DPHale William J · Whitehouse, TXN569DWBranched Oak Charter LLC · Rising City, NEN569FGMustang Sally Aviation LLC · Camden, SCN569FLN7396w LLC · Coeymans Hollow, NYN569JMInternational Air Services Inc Trustee · Carson City, NVN569KCross Timbers Aviation LLC · Bedford, TXN569MKindred Daniel P · Jacksonville, ILFirst renewal noticeN569MTMiddle Tennessee State University · Murfreesboro, TNN569NDVertol Systems Co Inc · Destin, FLN569PKWorld Aircraft Inc · Wagener, SCN569RHEvans Lawrence · Ocala, FLN569RVRicketts Michael D · Weirsdale, FLN569SPGlobal Flight Training Solutions Inc · Immokalee, FLN569TCGablin Theodore J · Calimesa, CAN569TJAnderson Thomas C · Poplar Grove, ILN569TLRotermund Brett L · Fairbanks, AKN569TSBig South Fork Aero Inc · Huntsville, TNN569WHGp Cub Air LLC · Sioux Rapids, IAN56ABBezanson Adam M · Fremont, NHN56AKLonghorn Leasing LLC · Anchorage, AK
Back to AD 2007-04-19 R1