AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N7511MDacus Jon Gremard · Jonesboro, ARN7511TDonohue Jack L · Imperial, CAN7512MDewolfe Cheyne Z · Cave Creek, AZN7512TCaldwell S F Bud · Paradise, CAN7513BWood Kent A · Holmes Beach, FLN7513CThomas Ronald L · Green Cove Springs, FLN7513ERag Wings And Radials Aircraft Leasing LLC · Georgetown, DEN7513XN7513x LLC · Cottonwood, CAN7514MBergner Nicholas K · Avon, MNN7514TRohsner Thomas A · Nacogdoches, TXN7514XBrown Thomas · Austin, TXN7515BJeffryes Richard B · Creswell, ORN7515CPrater Jon Aaron · Palm Coast, FLN7515GFrisbee Alice Molnar · Port Charlotte, FLN7515TGbl Leasing LLC · Gun Barrel City, TXN7515UUren Peter J · Redwood Falls, MNN7515XSnap Aviation LLC · Athens, PAN7516CLubben Justin K · Dayton, VAN7516MTobin Ardis C · Cheney, WAN7516TSchehl Darren C · Gahanna, OHN7517EVanherck Glen D · Bonne Terre, MON7517GDecember 1944 LLC · Las Vegas, NVN7517XHalley Dan R · Avery, TXN7518BMaxwell Richard H · Grove City, PAN7518MGearin Chad · Portland, ORN7518TWilliams Doyle D · Browning, MON7519CCooke Riley O · Bridger, MTN7519TScud Air 19t LLC · Morgan, UTN7519XSouthern Moulding Acquisition LLC · Marietta, GAN751CChiappe Eugene · Granbury, TXN751DSHigh Exposure Inc · Wilmington, DEN751LSSimpson Simpson Inc · Castana, IAN751WBRockhut Aviation LLC · Abilene, TXN7520BGreen William D · Fairbanks, AKN7520CKimball Hyland F · Columbus, NMN7520MWhitehurst Funeral Chapels Inc · Los Banos, CAN7520THartley Chester E · Holts Summit, MON7520XSunwave Land LLC · Big Spring, TXN7521BBarnick Ryan E · Montpelier, NDN7521CKorn Kenneth A · Tallahassee, FLN7521TPerry Kenneth C Jr · Tucson, AZN7521XWainwright Donald W · Live Oak, FLN7522BTailwheelin LLC · Richland, WAN7522MJohanson Mark E · Ivins, UTN7522TMoffitt Michael M · Wolcottville, INN7522XZitterkopf Gary N · Casper, WYN7523MW R Aviation Inc · Stigler, OKN7524EWaterbury Farms · Gridley, CAN7524MRange Shaun M · Brighton, MIN7524TBohn Flying LLC · Tijeras, NM
Back to AD 94-05-05 R1