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.
N495CPIris Fliers Inc · Fernandina Beach, FLN495DBWolfson Jason · Duxbury, MAN495EMAround The Patch LLC · Memphis, TNN495EREmbry-Riddle Aeronautical University · Daytona Beach, FLN495FLUrban Thomas L · Glencoe, MNN495GEastern Stearman Inc Trustee · Leesburg, VAN495GCCunningham John · Naperville, ILN495HCheyney Daniel J · Nine Mile Falls, WAN495JCCampillo Jorge A · Miami, FLN495KKatmai Air LLC · Anchorage, AKN495KCArgenta Acquisitions LLC · Little Rock, ARN495KLJones Christopher Brandt · Auburn, ALN495LAPiper 3 LLC · Chestnut Ridge, NYN495MCC182t LLC · Chattanooga, TNN495PLIntegrity Aircraft Title Holdings LLC · Portland, ORN495RDCapital Holdings 226 LLC · Naples, FLN495RFStewart Delbert G · Kent, OHN495SLAlair Scott C · Pleasanton, CAN495SPFlying Start Aero Services LLC · Reno, NVN495TCRegistered aircraftN495TMMacdonald Kenneth A · Willow, AKN495WWNational Aircraft Leasing Corp · Greenville, DEN4960DRasmussen Scott M · Santa Cruz, CAN4960JPonderosa Airtankers LLC · Safford, AZN4960KShuck Drilling Co · Edgar, NEN4960LWynn Wora A · Scottsdale, AZN4960UHopkins Breck G · North Little Rock, ARN4961AGunson Robert S · Star, IDN4961ELafferty David W · Harrisburg, ORN4961GGardner Clifton T · Vernal, UTN4961JJones Charles W · La Follette, TNN4961KGirolami Philip · Fircrest, WAN4961LKral Aircraft LLC · Ocala, FLN4961PSimmons Aviation Services LLC · Pawcatuck, CTN4961THatami-Nezhad Jamshid · Encino, CAN4961YSprenger Michael T · Hawley, MNN4962DMcdonald Richard Reid · Rock Island, WAN4962FEvans Dick G Trustee · Riverside, CAN4962GVersteeg Martin · San Antonio, TXN4962JHuffman Jacob M III · Burleson, TXN4962VAircraft Partner Holdings Inc Trustee · BerlinN4963GSunwest Aviation Inc · Santa Ynez, CAN4963LBakk Dale A · Nikiski, AKN4963NHarrison Earl S · Clarksville, TNN4963UAllen Shanda · Aynor, SCN4964AThree Sisters Capital LLC · Visalia, CAN4964DGrizzly Air Service Inc · Paris, TXN4964FTeam Builders Inc · Carson City, NVN4964GCrotts Aircraft Service Inc · Dodge City, KSN4964JShteyn Vladlmir · Huntingdon Valley, PA
Back to AD 2007-04-19 R1