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.
N4467RBrackett David E · Line Lexington, PAN4467SK & M Leasing Inc · Camden, ARN4467YKingsley Kiman J · Miller, MON44682Weatherbie Karen S · Centennial, CON44686Boca Flying Club Inc · Boynton Beach, FLN4468JCentral Arkansas Flying Club Inc · Bryant, ARN4468RSchmitt Dillon Allen · Caledonia, MIN4468SKyle Robert K · Madison, MSN4468TSpitzer Helicopter LLC · Wilmington, DEN4468WBorth John D · Meade, KSN4468YBegrow Adroaldo Dorivaldo · Gulf Shores, ALN44690H&M Air LLC · Metamora, MIN44691One Zero Charlie Aviation LLC · Cary, ILN44696Elliot Jerry B · Mount Pleasant, MIN44697Viets Bret A · Buffalo, MON4469AStacy Richard E · Westfield, NYN4469WDietle Kurt D · Valley Springs, CAN446ACRegistered aircraftN446ALValiair Lc Trustee · Casper, WYN446ASFreeman Tim B · Haymarket, VAFirst renewal noticeN446BBJb Buffalo LLC · Frisco, TXN446BGBowling Green Flight Center LLC · Bowling Green, OHN446BLBlue Line Aviation LLC · Smithfield, NCN446CACivil Air Patrol · Maxwell Afb, ALN446CSSocal Pilot Center · La Quinta, CAN446DCAircraft Guaranty Corp Trustee · Oklahoma City, OKN446DSFun Air LLC · Houston, TXN446ERWingsleasing LLC · Wichita, KSN446GWPrati Paul B · El Paso, TXN446HSUS Department Of Agriculture · College Station, TXN446JRSpangler John T · Mount Pleasant, PAN446KWClementi Frank R · Wesley Chapel, FLN446MKNorth Star Aviation · Mankato, MNN446MMInternational Air Services Inc Trustee · Carson City, NVN446PAHillsboro Aero Academy LLC · Hillsboro, ORN446PCStatius-Muller Robert C Trustee · Stamford, CTN446RDwons Roland Joseph · Oro Valley, AZN446RMRocky Mountain College · Billings, MTN446SPLam Capital Management LLC · Sheridan, WYN446TThatcher James W · La Canada Flt, CAN446TCChena River Aviation Inc · Fairbanks, AKN446TTC5 Aviation LLC · Sheridan, WYN446YBBeal James M Trustee · Eugene, ORN44702Shawback Brian D · Anchorage, AKN44704Bender Aviation Services Inc · Clearwater, FLN44705Warden James L · West Milford, NJN44708Interthal Mike · Butler, PAN4470AAnderson Stephen A · Yuba City, CAN4470JBister John C · Culver, ORN4470SFreitag Don M · Manhattan Beach, CA
Back to AD 2007-04-19 R1